Creating crosstable

[#1]

Dear Experts:

I have a table of billing totals per month & customer, like that:

CustomerID,BillingMonth,Amount

100;01;3000

100;02;5000

100;03;4000

101;01;3003

102;02;8004

103;03;403

I need to display the data as a crosstable (each month should be represented as a column):

CustomerID;01;02;03;04

It sounds like the opposite of the "crosstable" command.

there is is a way to do that without complicated macros?

Thanks,

Shlomo

[johnw · Accepted solution]

Just display it that way? Pivot table with CustomerID and BillingMonth as dimensions, drag BillingMonth to the top.

If you want to do it in your data structure itself, look into "generic load", which is the opposite of "crosstable load".

[#3]

Thank you very much John.