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
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
L

Legacy 51064

Guest
Here is non VBA solution

You can do a pivot table

Row= Name column
Column = Date
Data = sum of amount
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,127
Messages
5,857,528
Members
431,883
Latest member
Hien

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top