Transpose rows into columns

[#1]

Hi all.

I have this table.

Project	Work	Price 2014
Project_1	Documentation	1000
Project_1	Constraction	2000
Project_1	End	3000
Project_2	Documentation	1500
Project_2	Constraction	2500
Project_2	End	3000

How I can create this table?

Project	Documentation	Constraction	End
Project_1	1000	2000	3000
Project_2	1500	2500	3000

I must use crosstable?

Thank you.

[Gysbert_Wassenaar · Accepted solution]

No, the opposite: a generic load.

Generic

LOAD * INLINE [

    Project, Work, Price 2014

    Project_1, Documentation, 1000

    Project_1, Constraction, 2000

    Project_1, End, 3000

    Project_2, Documentation, 1500

    Project_2, Constraction, 2500

    Project_2, End, 3000

];

See attached qvw

[#3]

Thank you!