Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi there,
Can't quite wrap my head around this one. I have the following data: Ee# Contact Type Contact 1 Home P 111-2222 1 Email 2 Home P 222-3333 3 Home P 333-4444 3 Mobile 444-5555 3 Email 4 Mobile 555-6666 And need to make this Ee# Home P Mobile Email 1 111-2222 - 2 222-3333 3 333-4444 444-5555 4 555-6666 Any suggestions? Many thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Transpose columns to rows using first columns repeated. | Excel Worksheet Functions | |||
Transpose not working rows to columns | Excel Discussion (Misc queries) | |||
How do you transpose rows to columns? | Excel Discussion (Misc queries) | |||
TRANSPOSE 'group' of columns to rows | Excel Discussion (Misc queries) | |||
how do I transpose columns and rows | Excel Discussion (Misc queries) |