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

--
jace
-----------------------------------------------------------------------
jacef's Profile: http://www.excelforum.com/member.php...fo&userid=1454
View this thread: http://www.excelforum.com/showthread.php?threadid=26179