Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Rearranging Data
Hi,
I have 51 numbers in a row that I want to efficiently rearrange into columns in groups of three. EXAMPLE DATA Current arrangement: 1 2 3 4 5 6 7 8 9 Desired arrangement: 123 456 789 I have over 300 rows that are arranged like this and a total of 51 columns. I tried TRANSPOSE but I am not sure that is the best method. Any help is greatly appreciated! Thank You! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rearranging data | Excel Discussion (Misc queries) | |||
Rearranging data | Excel Programming | |||
Rearranging data | Excel Discussion (Misc queries) | |||
rearranging data | Excel Programming | |||
Rearranging Data | Excel Programming |