Help needed arranging data for Pivot table

  • Thread starter Thread starter jacef
  • Start date Start date
J

jacef

I have a very large table in excel that I need to create a pivot tabl
for, but can't seem to arrange the data correctly. Here's what th
table looks like: There are about 20 "type" columns across the top
and down the side are dates. For each day each of the columns ha
about 20 prices. So a big block of mostly price data is added eac
day. Do I have to have all of the prices in one column if I want t
view different "types" side by side in a pivot table? If so, I woul
have many many times the 65,000 rows that excel allows. This als
seems ridiculously redundant. It seems like I should be able to use m
existing list to do this. Any help is appreciated, and please ask m
any questions for clarification. Thanks
 
Hi
a pivot table requires a database like structure. If you have so many
data you may consider using a database application and let Excel access
this database to create a pivot table
 
Back
Top