I have a very large dataset which changes information and size on a daily basis (data is pulled from a very old, not very user friendly WMS).
I need to add a column to count how many unique item numbers are on each order number in a similar format as the snippet below if possible.
Problem is that I am unable to remove duplicates or add filters because each line has unique data that is used elsewhere.
Any help with this would be greatly appreciated!
Thanks in advance

I’m creating a check list that I have to add data to over time. I’m exporting the data from a large personnel file that has people being added to it as we progress through the project. Each time I export, I have to get every entry, I can’t filter based on date.

I need to remove rows based on duplicate column content
enter image description here