Dear All helpers
I simply need to split a cell ( a column of cells ) into two rows keeping the same content. So Cell A1 will become B1/B2, A2 will become B3/B4 and so on.
Cheers
Dear All helpers
I simply need to split a cell ( a column of cells ) into two rows keeping the same content. So Cell A1 will become B1/B2, A2 will become B3/B4 and so on.
Cheers
Column A already has values in it. So if "A1 becomes..." anything you'll lose the data in column A.
Don't you mean
B1/B2 will become A1
B3/B4 will become A2
etc
If so
in B1
=INDEX(A$1:A$1000,(ROW()-1)/2+1,1)
and copy down the column
Note data will be zeroes in column B once you go beyond 2*(number of rows in column A)
Last edited by Special-K; 08-03-2021 at 10:23 AM.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Hello
I actually want column A1 to splint into B1/B2, A2 into B3/4 and so on but keeping the very same cell content (word) in each new B cell.
Thanks
Give this macro a try...
Please Login or Register to view this content.
Or try this in B1:
=INDEX(A:A,ROWS($A$1:A2)/2)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks