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]

How many rows is your data?

more than 3 million. But it will be less as we group them in company names.

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

I want it to be
--------------------Company A-----company B-------company C
15/05/2015-------8.85--------------8.98-----------------9.87
16/05/2015-------8.98--------------8.69-----------------10.98

Thank you

 

[Drrellik]

Is this something you can just transpose the first column?

insert (A) row. at the top highlight A2:A?? copy and then select C1 right click paste special Transpose.

not sure how much data you have.

 

[sheetspread]

(I should've said in my first post companies go in columns, dates in rows, price in values but you probably figured that out)

If you're not grouping the dates (e.g. 1/2/16,1/3/16,1/14/16 would all be combined into January 2016) try this:

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

 

[Myura]

Is this something you can just transpose the first column?

insert (A) row. at the top highlight A2:A?? copy and then select C1 right click paste special Transpose.

not sure how much data you have.

I do not thik it will work. I have 3 million rows. so I cannot perform this on excel itself.

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

I want it to be
--------------------Company A-----company B-------company C
15/05/2015-------8.85--------------8.98-----------------9.87
16/05/2015-------8.98--------------8.69-----------------10.98

Thank you

 

[Drrellik]

WOW that is a lot of row's excel 2013 can only handle just over 1 million rows and a Pivot table that big would choke my little machine.....

 

[Myura]

(I should've said in my first post companies go in columns, dates in rows, price in values but you probably figured that out)

If you're not grouping the dates (e.g. 1/2/16,1/3/16,1/14/16 would all be combined into January 2016) try this:

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

I have tried the same. but error message saying "The pivottable report will not fit the sheet".

 

[Drrellik]

Keep It Simple and Fast: Power Pivot: The PivotTable report will not fit on sheet.

 

[sheetspread]

I have tried the same. but error message saying "The pivottable report will not fit the sheet".

How many columns (companies) are there?

 

[ImkeF]

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".

 

[Myura]

How many columns (companies) are there?

around 96,000 companies. I know it is big *** annoying data set.