Pivot table help

[lj]

Hi, I'm using an excel spreadsheet and I have a list of customer
numbers in column A and a list of account numbers in column B. Many
customers have more than 1 account number. What I would like to do is
change the layout so that I have each customer number listed only once
and have all of the account numbers corresponding to the customer
number in the same row (so for example I would have customer number in
A:1, account number 1 in B:1, account number 2 in B:2, account number 3
in B:3 ect) . Is there a way to do this? Is it possible to do this in
a pvt table? Thanks.

 

[David McRitchie]

SNAKECOLS, How to snake columns to use fewer pages
http://www.mvps.org/dmcritchie/excel/snakecol.htm#joining

This will put the account numbers into cell B separated by
commas, not your exact request but does provide the information
in the order you asked for.