| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 | |||
| Transposing One Column to Multiple Rows | Excel Worksheet Functions | |||
| Transposing columns to rows | Excel Discussion (Misc queries) | |||
| transposing data from 1 column into multiple rows | Excel Discussion (Misc queries) | |||
| Transposing a column to several rows | Excel Discussion (Misc queries) | |||
| Transposing a column to several rows | Excel Worksheet Functions | |||
Threaded Mode
