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