Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I have been given a lot of data which is formated in the wrong way and wondered if there was a solution to format it into the right order? The data looks like this Unique ID Tel Type Number 1234 Home 012345678 1234 Mobile 987654321 4321 Home 12345678 4321 Mobile 654987123 and it should look like this Unique ID Tel Type Number Tel Type Number 1234 Home 012345678 Mobile 987654321 4321 Home 12345678 Mobile 654987123 Many thanks Michael |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Merging Columns | Excel Worksheet Functions | |||
Merging Two Columns | Excel Discussion (Misc queries) | |||
merging columns | New Users to Excel | |||
Merging columns | New Users to Excel | |||
Merging Columns | Excel Worksheet Functions |