ETL and Data Integration tools - Modern ETL software for everyone

Hey

I have a file like this

Name,Peter
Dob,01/01/1958
Name,Maria
Dob,01/01/1968

and I want produce something like this

Name,Dob
Peter,01/01/1958
Maria,01/01/1968

How can I do it or is it possible at all?

Stardust

What you need to do is to number your records using calcuation

so your data data will look like

1,Name,Peter
2,Dob,01/01/1958
1,Name,Maria
2,Dob,01/01/1968

Than use pivot transformation

Watch this online tutorial you will get an idea
www.dbsoftlab.com/online-tutorials/advan...ivot-and-sorter.html

Peter