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

 

[sheetspread]

Like in the regular pivot table, put the date field in columns, companies in rows, price in values.

 

[Myura]

Thank you for your reply. But unfortunately I'm new to power BI. I just learned to upload the csv file. Could you please guide me with steps to achieve it. It would be much appreciated.
Thanks again.

 

[sheetspread]

Here's how to set up the table:

https://www.youtube.com/watch?v=HCPRegwjtVE

But follow what I wrote above when arranging the fields.

 

[Myura]

Thank you so much. I was helpless until I found this Forum. And you are a star sheetspread.

 

[Myura]

Here's how to set up the table:

https://www.youtube.com/watch?v=HCPRegwjtVE

But follow what I wrote above when arranging the fields.

I could not find the button for power pivot in Power BI.

 

[Drrellik]

I think the short cut keys for PT are ALT+D, P

 

[Myura]

I tried that short cut in the PowerBI desktop, and it is not working. I tried as the video shows in Excel, but my data is too large, so it cannot transform all rows to columns. Thats why I thought Power BI could be a solution for this.

 

[sheetspread]

I could not find the button for power pivot in Power BI.

It should be in the powerpivot ribbon, are you seeing that above? If not, you can set it through the file menu. I've only tried the shortcut that Drrellik posted with regular pivot tables, but see if it works (Alt-D-P).

 

[sheetspread]

I tried that short cut in the PowerBI desktop, and it is not working. I tried as the video shows in Excel, but my data is too large, so it cannot transform all rows to columns. Thats why I thought Power BI could be a solution for this.

How many rows is your data?