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...ol.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.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"lj" <[email protected]> wrote in message news:[email protected]...
> 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.
>