+ Reply to Thread
Results 1 to 7 of 7

Data modification

  1. #1
    Registered User
    Join Date
    05-15-2019
    Location
    india
    MS-Off Ver
    2018
    Posts
    6

    Data modification

    i have large data with spaces between them. i want to code so that the data in the above cell is copied in the cell with no data.
    For example the data i have is
    1

    2

    3

    4

    i want this data to be modified as
    1
    1
    2
    2
    3
    3
    4
    4

    Do help me out?

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Data modification

    You could use Data -> Get & Transform and use a Fill Down function if you are familiar.

  3. #3
    Registered User
    Join Date
    05-15-2019
    Location
    india
    MS-Off Ver
    2018
    Posts
    6

    Re: Data modification

    how to use a fill down function??

  4. #4
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Data modification

    If you have Excel 2016;

    1) Select your data
    2) Go Data -> From Table
    3) Make sure 'My table has headers' is unchecked
    4) Press OK
    5) Next window select Transform -> Fill -> Down
    6) Close and Keep
    7) Output should display on a new sheet

  5. #5
    Registered User
    Join Date
    05-15-2019
    Location
    india
    MS-Off Ver
    2018
    Posts
    6

    Re: Data modification

    can you tell the procedure of excel 2018

  6. #6
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Data modification

    I can't no. Is there nothing similar in my steps?

  7. #7
    Registered User
    Join Date
    05-15-2019
    Location
    india
    MS-Off Ver
    2018
    Posts
    6

    Re: Data modification

    thank you so much the same steps is working

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA code for data retrieval and modification.
    By smeetvicky in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-01-2013, 10:22 AM
  2. Modification of VBA code to arrange data.
    By fatalcore in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-14-2011, 02:14 PM
  3. Locking Data after 1st Modification
    By jostrom in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-26-2009, 02:04 PM
  4. data modification
    By deepak.kec in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-23-2009, 04:39 PM
  5. data extraction and modification
    By analyst1012 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-22-2008, 09:11 AM
  6. Data Modification? .....
    By KrakaJap in forum Excel General
    Replies: 2
    Last Post: 11-10-2007, 05:34 PM
  7. Data Modification
    By Syed Haider Ali in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-15-2006, 06:55 PM
  8. Lock to copy/ modification data
    By ilyaskazi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-14-2005, 03:42 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1