Forum Discussion
Excell formula help
Hi, I would like help to merge multiple rows and columns into one continuous row. Eg - all data to be spread across A1,B1,C1,D1,E1,F1,G1,H1,I1,J1,K1 etc FROM: B4,C4,A6,B6,A7,B7,B8,A9,B9,A11,B11 - Is there an easy formula to do this? Thank you
24 Replies
Hi,
Start this formula in cell A1 then drag it to the right:
=CHOOSE(COLUMN(),$B$4,$C$4,$A$6,$B$6,$A$7,$B$7,$B$8,$A$9,$A$11,$B$11)
Hope that helps
Thank you Haytham Amairah - What do you mean "drag it to the right"? I have 12,000 lines of data I am trying to format across the rows.
I mean copying the formula to the next right cells by dragging the first cell using the https://www.youtube.com/watch?v=kgGF136-kIg.
