Excel - solution to (quickly) remove duplicate and change format

[NielsvB]

Hello,

I currently have an Excel sheet which contains the data of order numbers, account name, service, productname (orderitem) and price per orderitem.
Is there a way to change the data and format to remove the order number duplicates and spread out the order line items (and price) over different columns in a fast way?

Please see attached Excel document for an example. In the first tab 'Current format' you can see how it's currently existing in the datasheet.
On the second tab 'Req. format' you can find an example of how I would like the document/ data to be.

Manual adjusting wouldn't be practical, since the original document contains thousands of records.
(Btw, I don't even know if it's possible to make a quick solution for this. If this isn't possible you can tell me as well and I will try to find a different solution instead).

Thanks in advance!

~ Niels

[Glenn Kennedy]

In A2, copied down:
=IFERROR(INDEX('Current format'!$A$2:$A$14,MATCH(0,INDEX(COUNTIF($A$1:$A1,'Current format'!$A$2:$A$14),0),0)),"")

In B2, copied acriss and dnown:
=IF($A3="","",VLOOKUP($A2,'Current format'!$A:$C,COLUMNS($A:B),FALSE))

In D2, copied across and dnown:
=IFERROR(IF($A2="","",INDEX('Current format'!$E:$F,AGGREGATE(15,6,ROW('Current format'!$E$2:$E$14)/('Current format'!$A$2:$A$14=$A2),1+INT((COLUMNS($D:D)-1)/2)),1+MOD((COLUMNS($D:D)-1),2))),"")

[NielsvB]

In A2, copied down:
=IFERROR(INDEX('Current format'!$A$2:$A$14,MATCH(0,INDEX(COUNTIF($A$1:$A1,'Current format'!$A$2:$A$14),0),0)),"")

In B2, copied acriss and dnown:
=IF($A3="","",VLOOKUP($A2,'Current format'!$A:$C,COLUMNS($A:B),FALSE))

In D2, copied across and dnown:
=IFERROR(IF($A2="","",INDEX('Current format'!$E:$F,AGGREGATE(15,6,ROW('Current format'!$E$2:$E$14)/('Current format'!$A$2:$A$14=$A2),1+INT((COLUMNS($D:D)-1)/2)),1+MOD((COLUMNS($D:D)-1),2))),"")

Thanks a lot!

[Glenn Kennedy]

You're welcome and thanks for the rep.