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]

Powerpivot and Power Query can definitely do this, even up to 100 million rows and several million columnns (which I'm told is very slow). How far exactly did you get with Powerpivot?


even though you must be tired of all these links, this one shows you how to get the csvs into powerpivot:

http://www.quepublishing.com/articles/article.aspx?p=1613314&seqNum=2

 

[Myura]

Powerpivot and Power Query can definitely do this, even up to 100 million rows and several million columnns (which I'm told is very slow). How far exactly did you get with Powerpivot?


even though you must be tired of all these links, this one shows you how to get the csvs into powerpivot:

Getting Your Data into PowerPivot | The Promise of PowerPivot in Excel 2010 | Que

Thank you so much for your help. I'm not in the state to get tired .
76,519 companies got in to one sheet.

 

[sheetspread]

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

Bill imports 7 million rows here (and this was the 2010 version)

 

[Myura]

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

Bill imports 7 million rows here (and this was the 2010 version)

He is showing the table in data model, not in the sheet. when we need the pivot table, it goes to sheet where we have restrictions.

 

[Myura]

In the query editor in PBI desktop or Power Query you can pivot large data like described here: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-common-query-tasks/
Check the options in the "Aggregate Values" - you might want to choose "no aggregation".

Thank you so much for your help. You saved my day. It worked. Thanks again.

 

[Myura]

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

Bill imports 7 million rows here (and this was the 2010 version)

I have managed to do it as ImkeF intructed. Thank you so much for your help. You are a champ.

 

[Myura]

In the query editor in PBI desktop or Power Query you can pivot large data like described here: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-common-query-tasks/
Check the options in the "Aggregate Values" - you might want to choose "no aggregation".

I have managed to transform it in the Queries panel. But it cannot be used in the Power Bi tool as it can only allow 16,000 columns, mine is way too far from this.

 

[sheetspread]

Why aren't you putting the companies in rows?

 

[ImkeF]

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.

 

[Myura]

Why aren't you putting the companies in rows?

Yeah. May be I should formulate my research in other form. I will try and see. Thank you so much for all your help.