I have data in the following format:
Name Date Amount
Johnson 6/1/06 $100
Johnson 6/6/06 $300
Johnson 6/13/06 $350
Smith 6/2/06 $450
Smith 6/5/06 $100
Jones 6/16/06 $225
Every month the amount of times the name shows up will be different as well
as the dates they used the money.
I have different sheets for each name but i need to pull the dates and
amounts into seperate columns being:
Date Amount
Any help is greatly appreciated!
Cillian - 21 Jun 2006 16:28 GMT
Hi Brett,
could you give an example of how you want the data to look?

Signature
Cillian
> I have data in the following format:
>
[quoted text clipped - 15 lines]
>
> Any help is greatly appreciated!
Brett - 21 Jun 2006 16:35 GMT
JOHNSON
Date Amount
6/1/06 $100
6/6/06 $300
6/13/06 $350
> Hi Brett,
>
[quoted text clipped - 19 lines]
> >
> > Any help is greatly appreciated!
Marcelo - 21 Jun 2006 17:53 GMT
Hi Brett, did you try a Pivot Table?
HTH
Regards from Brazil
Marcelo
> JOHNSON
> Date Amount
[quoted text clipped - 25 lines]
> > >
> > > Any help is greatly appreciated!
Brett - 21 Jun 2006 18:12 GMT
I thought about the same thing but my boss wants it to be in the format i
have listed. Thanks anyways
> Hi Brett, did you try a Pivot Table?
>
[quoted text clipped - 31 lines]
> > > >
> > > > Any help is greatly appreciated!
Brett - 22 Jun 2006 14:50 GMT
Would a pivot table be the only way to do this?
> I have data in the following format:
>
[quoted text clipped - 15 lines]
>
> Any help is greatly appreciated!