Transform Rows to columns

[Myura]

Hi!
Please help me with my thesis research. I have downloaded huge data set to analyse.
For the first step, I want to transform the data. I want dates to be in the rows, and company names to be in the columns.
Currently it is like this;

Name Date Price
Company A 15/05/2015 3.5
Company A 16/05/2015 4.5
Company B 15/05/2015 3.5
Company B 16/05/2015 4.5


Mush appreciated for your help

 

[Myura]

Yes, the question is what you want to achieve with your query at all.
Why the unpivot-step? That many columns will be hard to handle everywhere.

I'm going to try to keep companies in rows and formulate my other variables to adjust this form. Thank you so much for all your help.

 

[sheetspread]

Companies in rows, dates in columns. With grouping and the value field setting you can show monthly or yearly average prices, that will reduce the column size by a lot. Unless you must show each day, which to me seems excessive.