Changing Rows to Columns

[Reporter]

I have a table (simplified) that contains data like:

Customer Policy
A ............1
A ............2
A ............3
B ............4
B ............5

I need to get the output into Excel in the format

Customer PolicyCount Policy Policy Policy
A ................3.......... 1...... 2...... 3
B ................2.......... 4.......5

I have a limited knowledge of Access, but I am thinking that I need to count Policy grouped by Customer....which I can do. Then I am thinking I need to do a running count of policies, re-setting the count on each Policy and cross-tab on the count of policies. So the running count for customer A would be 1,2,3 and for Customer 1,2

BUT not sure how to do a running count (have read about DSUM) ....and maybe there is a simple way to achieve this!

Any help greatly appreciated.

 

[Poppa Smurf]

Customer Policy
A ............1
A ............2
A ............3
B ............4
B ............5


Customer PolicyCount Policy Policy Policy
A ................3.......... 1...... 2...... 3
B ................2.......... 4.......5

If you require your output to show Customer, the number of polices, and the policy number for each Customer then you will need to use code and do your data manipulation using an array etc.