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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create column with data pulled from header row
I have copied you input data to A1:F8
So I have DD1, DD2 etc in B1:F1 I have 501, 502.... in A2:A8 I copied A2:A8 to I2:I8 (but this cold be anywhere else) In J2 I used =INDEX($B$1:$F$1,MATCH(1,B2:F2)) I copied this down to J8 Now I have the table you asked for best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Kirk Ace Art" <Kirk Ace wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create column with data pulled from header row
Bernard,
That was great; I've been trying to figure this out on my own for a week. I posted and had an answer in 10 minutes. Thank you, thank you, thank you, Kirk "Bernard Liengme" wrote: I have copied you input data to A1:F8 So I have DD1, DD2 etc in B1:F1 I have 501, 502.... in A2:A8 I copied A2:A8 to I2:I8 (but this cold be anywhere else) In J2 I used =INDEX($B$1:$F$1,MATCH(1,B2:F2)) I copied this down to J8 Now I have the table you asked for best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Kirk Ace Art" <Kirk Ace wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create column with data pulled from header row
You are most welcome
-- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Kirk Ace Art" wrote in message ... Bernard, That was great; I've been trying to figure this out on my own for a week. I posted and had an answer in 10 minutes. Thank you, thank you, thank you, Kirk "Bernard Liengme" wrote: I have copied you input data to A1:F8 So I have DD1, DD2 etc in B1:F1 I have 501, 502.... in A2:A8 I copied A2:A8 to I2:I8 (but this cold be anywhere else) In J2 I used =INDEX($B$1:$F$1,MATCH(1,B2:F2)) I copied this down to J8 Now I have the table you asked for best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Kirk Ace Art" <Kirk Ace wrote in message ... 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 |
Reply |
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) |