Complex Reformatting

Hanz77

Board Regular
Joined
Sep 21, 2006
Messages
87
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
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
L

Legacy 51064

Guest
Here is non VBA solution

You can do a pivot table

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

Watch MrExcel Video

Forum statistics

Threads
1,114,384
Messages
5,547,621
Members
410,804
Latest member
bluepinky
Top