I have a range of data in columns A but need to align the second row on the same row 1
Fourth row on same of third row and so on.
Looking a formula to achieve this
I have a range of data in columns A but need to align the second row on the same row 1
Fourth row on same of third row and so on.
Looking a formula to achieve this
C1 =indirect("a"&1+(row()-1)*2)
d1 =indirect("a"&2+(row()-1)*2)
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks