Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have roows of data looks that look like this:
Text1 Text1 Text1 Text1 1 2 3 4 5 6 7 8 9 10 11 Text2 Text2 Text2 Text2 1 2 3 4 5 6 7 8 9 10 11 Text3 ...... I'm trying to convert the above to look like this: Text1 Text1 Text1 Text1 1 2 3 4 5 6 7 8 9 10 11 Text2 Text2 Text2 Text2 1 2 3 4 5 6 7 8 9 10 11 Text3..... I created a macro within Excel to arrange the Text1 data, but how can I continue reading and arranging the next rows within the macro to repeat what was done to the first one? I assume it's a Do Loop, but just need the code to force it to read Row2 and repeat the same process for an "n" number of rows. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
repeated conversion of data summarized into rows and columns | Excel Discussion (Misc queries) | |||
Transpose columns into continuous rows | Excel Worksheet Functions | |||
Data Conversion - times, dates & rows | Excel Worksheet Functions | |||
Turning rows of equal number of columns into 1 continuous row | Excel Worksheet Functions | |||
Continued Conversion of data from rows to columns in a macro. | Excel Programming |