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
Bookmarks