Problems arranging data for Pivot table

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Arranging data for Pivot table creation????? 1
Help needed arranging data for Pivot table 1
Help needed arranging data for a pivot table 1
Column limit for Pivot Table data source 1
pivot table counting 1
Pivot Table Formula not multiplying correctly 2
Pivot table wizards 2
Question on the occupied field of the pivot table in excel spreadsheet 0

Top