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.