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?
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?
You could use Data -> Get & Transform and use a Fill Down function if you are familiar.
how to use a fill down function??
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
can you tell the procedure of excel 2018
I can't no. Is there nothing similar in my steps?
thank you so much the same steps is working
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks