| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
special type of rows to columns procedure
This is how i have the data
column1 column2 column3 column4 row1 1 2 3 4 row2 5 6 7 8 row3 9 10 11 12 And this how i would like to transform it with the most automated way i can. column1 column2 column3 column4 row1 1 row2 2 row3 3 row4 4 row5 5 6 7 8 row6 9 10 11 12 Which means that i'd like Excel to insert new rows in order to paste the "transposed" data and move the rest or the rows down. I hope i was a bit more clear this time...and please excuse my not proficient english!!! Thank you in advance. Stavros from CRETA SUPPLIES instead of just |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
| Converting Columns to Rows | Excel Worksheet Functions | |||
| How do I lookup values from rows and columns Simultaneously | Excel Worksheet Functions | |||
| repeated transpose from rows to columns with unequal groups | Excel Discussion (Misc queries) | |||
| interchange columns with rows | Excel Discussion (Misc queries) | |||
Threaded Mode
