Matching Dates in Excel and Moving the rows to correspond with correct dates

Column A has dates over a given 10 year period (Often a single date appears more than once). Column B has each date only once and Columns C-G have values corresponding to each date in column B.

I want to create a macro or formula to identify each date in column A and align it with the corresponding date in column B as well as the corresponding values in Columns C-G.

Column A___________Column B___________Column C

1/1/1999___________1/1/1999___________0.45

1/1/1999___________1/2/1999___________0.54

1/1/1999___________1/3/1999___________0.23

1/2/1999

1/2/1999

1/3/1999


Any help or insight would be greatly appreciated, thanks.

Sure Attached

No, I'm sorry I meant to delete columns H and I. I would like to have the dates in the columns A and B be the same and bring the values in Columns C-G down into the same row as the corresponding dates in Columns A and B. I don't want to change anything with Column A.

Sure I apologize for not being more clear.

If you go down to the bottom of the spread sheet, I started with the date 4/20/13 in terms of how I would like it to appear for all dates (bolded)

I started to copy and paste for each date but realized this would take entirely too long.

Thanks!

At the very bottom of the updated excel file, you can see that there are nine dates of 4/20/13 in column A (Rows 15978-15986). I copied the values in Columns B-G from Row 1572 (corresponding to the same date of 4/20/13) into those last nine rows to match up the dates.

Yeah, I started with the last date and was going to go from bottom up. There are actually more values associated with each of those 9 lines for 20/04/13 which I have in another set, I don't want to bring those values in yet until I can get values from columns C-G figured out (if that makes any sense).