Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mapping Data from One worksheet to Another
I am trying to map data from one worksheet to another. All the data is in
text format and appears like this: A B x ab x cd y af y cw y te z re I want to map it to a different worksheet so that it appears like this x ab cd y af cw te z re So that for each of the items in the first coulumn of the first worksheet it displays the different sets that correspond to it in the same row in the second worksheet. I tried to use pivot tables but they only work with numbers I guess. Please help ASAP. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manual control of link updating for downloaded quotes? | Excel Discussion (Misc queries) | |||
Look up Data from Worksheet within same Workbook | Excel Discussion (Misc queries) | |||
Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Macro to search for and display data in another worksheet | Excel Worksheet Functions |