Yes and no, you could apply a pseudo pivot table, select the table, apply
the pivot table,
drag the customer field to the row, then drag the account field also to the
row, then drag
the customer field to the data, click finish. Now right click in the pivot
table and select entire table, copy
and paste it to a new sheet, apply autofilter on the first row, click the
dropdown in the first column and select custom, select

does not contain

and type

total

in the adjacent box, click OK, now select the first 2 columns in the
visible table, press F5, select special and visible cells only, copy and
paste somewhere else. That will give you your table in less than 5 minutes


--
Regards,

Peo Sjoblom

Portland, Oregon




wrote in message
oups.com...
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.