Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
On one worksheet, I have a "table" with a header column & header row, along
with data. ON another worksheet, I would like all of the data in the first worksheet to be in a list; the applicable column header would be placed into one column, the row header into another one. Example: Table on first worksheet: A X P 1 2100 2101 2102 2 2103 2104 2105 3 2106 2107 2108 Desired results on 2nd worksheet: A B C 2100 1 A 2101 1 X 2102 1 P 2103 2 A 2104 2 X 2105 3 P |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to do a lookup using multiple values | Excel Worksheet Functions | |||
Lookup multiple values | Excel Worksheet Functions | |||
Multiple lookup values and adding multiple rates across together | Excel Worksheet Functions | |||
Lookup on multiple values | Excel Discussion (Misc queries) | |||
Lookup in Multiple Columns, Return Multiple Values | Excel Worksheet Functions |