| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
dynamic search
I am exporting data that looks like this:
Subdivision Lot Date 1 Memo1 Line# Description 93101100000 0001 SPEC 10 Buyer 93101100000 0001 8/15/05 20 Color Selects 93101100000 0015 MODEL 40 Buyer 93101100000 0015 8/01/05 70 Color Selects I need to move all this data to make it look like this: Buyer Lot Color Selects SPEC 0001 8/15/05 MODEL 0015 8/01/05 There are currently 13 items repeating over and over and may or may not have data in them. I need help in the formula to convert this table. Any help is appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Dynamic Ranges: Speed Issue | Excel Worksheet Functions | |||
| Can't create dynamic charts | Charts and Charting in Excel | |||
| FAQ Spreadsheet with search function | Excel Discussion (Misc queries) | |||
| Dynamic charting problems (events) | Charts and Charting in Excel | |||
Hybrid Mode
