Complex Reformatting

[Hanz77]

I have three columns of data containing names, dates and $ amts.

Following is an abbreviated example:

....A..................B...............C.............
1 John Doe 1/1/2006 $15.00
2 John Doe 2/1/2006 $27.00
3 John Doe 3/1/2006 $12.00
4 Bill Dean 1/1/2006 $36.00
5 Bill Dean 3/1/2006 $22.00

I would like to get each name with their corresponding date and $ amt moved to one line. Essentially column A would have all of the names, column B would have all $amts for 1/1/2006, etc.

For example:

.......A.................B...............C...............D...........
1 Name 1/1/2006 2/1/2006 3/1/2006
2 John Doe $15.00 $27.00 $12.00
3 Bill Dean $36.00 $0.00 $22.00

The actual list contains about 900 names and nearly two years of $amts. I have been able to automate some of this; however, I don't think my methods are as efficient as they could be. Any thoughts of automating this are appreciated.

Thanks,
Hanz

 

[Legacy 51064]

Here is non VBA solution

You can do a pivot table

Row= Name column
Column = Date
Data = sum of amount