LinkBack URL
About LinkBacks
Hello, is there an easy way to duplicate cells to one row below? (see attached picture for example)
I need the simplest method since i have thousands of data to duplicate and my fingers are starting to hurt from manually copy-pasting it lol
Hello, is there an easy way to duplicate cells to one row below? (see attached picture for example)
I need the simplest method since i have thousands of data to duplicate and my fingers are starting to hurt from manually copy-pasting it lol
Last edited by ersyadiaz; 12-30-2019 at 04:29 AM.
Yes, like this:
=INDEX(A$2:A$5,1+INT((ROWS($1:1)-1)/2))
copied across and down. See sheet. Adjust the bit in red to suit your data.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Hi
simple method is that copy the data and paste below it and sort on NO.
or assume your data in A1:a1000
then
NO. =INDEX($A$2:$C$1000,INT(ROW()/2),1)
NAME=INDEX($A$2:$C$1000,INT(ROW()/2),2)
AGE=INDEX($A$2:$C$1000,INT(ROW()/2),3)
Thank you so much!
You're welcome.
If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks