| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create column with data pulled from header row
Hello,
I receive spreadsheets from a client that I need to extract a list from Here is what the spread sheet looks like when I get it: DD1 DD2 Q3 K1 K2 501 1 502 1 503 1 504 1 505 1 506 1 507 1 What I want to have at the end is this: 501 DD2 502 K1 503 DD1 504 K1 505 K2 506 Q3 507 DD1 If you can help me with a formula I'll be able to save tons of time. Thanks, Kirk |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Specific data pulled to new tab | Excel Discussion (Misc queries) | |||
| How do I manipulate data pulled from within an excel calendar? | Excel Discussion (Misc queries) | |||
| copying charts into new sheets, data is pulled from old sheet | Charts and Charting in Excel | |||
| Using AutoFilter to Sort Data Pulled in by INDEX / MATCH | Excel Worksheet Functions | |||
| Sorting data in a table by the header of a column? | Excel Discussion (Misc queries) | |||
Threaded Mode
