Convert rows to Columns

[Irina]

Hi people,

Can I by any chance convert data that was kept in rows into columns.

For instance:

name Mr X
street Unknown
city Unknown

name Ms X
street Unknown
city Unknown

into

name street city
Mr X Unknown Unknown
Ms X Unknown Unknown

Would really appreciate any hint.

Thanks a lot in advance,

Irina.

[dcronje]

If you select the data the copy and then select edit>pastespecial and tick the transpose box