+ 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)

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