Remove duplicates 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

[AliGW]

You have posted in the Outlook section - was this in error and would you like the thread moved to another section?

[NielsvB]

You have posted in the Outlook section - was this in error and would you like the thread moved to another section?

Created new one in correct section. You can close this one.

[bhausib23]

Filter for unique values, remove duplicate values, and conditionally format ... Article · Split text into different columns with the Convert Text to Columns Wizard