M
Michael
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
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