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 ...
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!
- Thank you anyway. Long story short is I have an account list of clients who have purchased from us. Name, Address, Suburb, Post Code, Phone Number etc etc and want to get them as mentioned above on one line across the sheet so I can then sort them by suburb. Eg - A1 = Name, B1 Address, C1 Suburb, D1 Post Code, E1 Phone Number. Too many clients to go through and cut & paste unfortunately.