| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Transposing a column to several rows
I have a large file with many rows; let's say it looks like this:
start data1 data2 data3 data4 start data1 data2 start data1 data2 data3 .... What I want to do is transpose the column to a row, and then each time the word START appears, start a new row. So the above would look like this: start data1 data2 data3 data4 start data1 data2 start data1 data2 data3 .... Any ideas? Thanks in advance, Scott |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort by row instead of by column? | Excel Worksheet Functions | |||
| Column Auto Width and Hidden Rows | Excel Discussion (Misc queries) | |||
| MACRO - copy rows based on value in column to another sheet | Excel Discussion (Misc queries) | |||
| every nth cell by columns not rows.... | Excel Worksheet Functions | |||
| Vary the column widths for different rows | Excel Discussion (Misc queries) | |||
Threaded Mode
