Pivit table question

[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.

 

[Max]

Yes, a pivot table is ideal for this

Assume source table in cols A and B,
data from row2 down

Cust# Acct#
1111 2222
1112 2223
1111 2224
1112 2225
1111 2226
1112 2227
etc

Steps: (in Excel 97, my ver, but should be similar)

Select any cell within the data
Click Data > Pivot Table Report
Click Next > Next

In step 3 of the wiz,
Drag and drop Cust# within the ROW area
Drag and drop Acct# within the ROW area, below Cust#
Drag and drop Acct# within the DATA area
If it appears as "Sum of Acct#", double-click on it, select "Count"
under "Summarize by", click OK. It should now appear as "Count of
Acct#".
Click Finish

The PT will be created in a new sheet to the left, and will yield the
desired results:

Count of Acct#
Cust# Acct# Total
1111 2222 1
2224 1
2226 1
1111 Total 3
1112 2223 1
2225 1
2227 1
1112 Total 3
Grand Total 6