Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rearranging data
I've been given some data that looks like this:
Name Docs Name1 doc1 Name1 doc3 Name2 doc2 Name2 doc3 Name3 doc1 Name4 doc1 Name4 doc2 Name4 doc3 Name5 doc1 Name5 doc3 Name6 doc3 and I need it to look like this: Name Doc1 Doc2 Doc3 Name1 X X Name2 X X Name3 X Name4 X X X Name5 X X Name6 X There are thousands of records but only three different doc types. For each Name, all three docs might be there, or only one, or any combination of two of them. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rearranging data | Excel Discussion (Misc queries) | |||
Rearranging DATA | Excel Discussion (Misc queries) | |||
rearranging data | Excel Programming | |||
Rearranging Data | Excel Programming | |||
rearranging data | Excel Programming |