Convert data from column layout to row layout

I receive a weekly spreadsheet and I am trying to change the layout from rows to columns. Column A contains a list of invoice numbers. Column E contains a list of Agent IDs for each invoice. As an example, it is formated as follows:

Invoice Number......Agent ID
333-444....................35-55
333-444....................652-355
66-22641..................43-355-442
66-22641..................12-344-111
66-22641..................25-359-877

I want to reformat so there is only one unique invoice number per row and the Agent IDs would be in same row. Desired output would be as follows:

Invoice Number.......Agent ID 1........Agent ID 2.......Agent ID 3
333-444....................35-55.................652-355
66-22641..................43-355-442 .....12-344-111.....25-359-877

Attached is example of data (in sheet 1) and desired output (in sheet 2). Any assistance is appreciated. Thanks.

Try this. On the RunSheet "Input Sheet" is the name of the input worksheet. "Output Sheet" is the name of the output sheet. Push the DoIt button and the macro will run.
Agent%20Split%20-%20Reformat%20Example(1).xls