Hi
see your other posts

--
Regards
Frank Kabel
Frankfurt, Germany


jacef wrote:
I have a very large table in excel that I need to create a pivot
table
for, but can't seem to arrange the data correctly. Here's what the
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 has
about 20 prices. So a big block of mostly price data is added each
day. Do I have to have all of the prices in one column if I want to
view different "types" side by side in a pivot table? If so, I would
have many many times the 65,000 rows that excel allows. This also
seems ridiculously redundant. It seems like I should be able to use
my existing list to do this. Any help is appreciated, and please ask
me any questions for clarification. Thanks.