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 ...
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.
- Thank you. Is there to do it for all 12,000 lines or do I need to re-write the formula?
If you have cells scattered in 12,000 rows, and you want to make them arranged in one line!
This formula will not help!I'm not sure if there is a solution to this case!