I have a spreadsheet listing products and other pertinent information on the same row but in a different colum.
The products are garment and each product/colour/size combination has its own individual row. This means that one product may take up as many as 20+ rows.
I would like to print the report but it is 54 pages long.
Does anybody know if it is possible to do a sort by a specific column and automatically remove duplicates? It doesn't really matter which line is kept but, if it makes a difference to the explanation, I would like to keep the f1st row and delete all subsequent lines.
Fortunately, for me, the product code is in a separate column from all the other information so it is easy to spot duplicates.
I could go through and delete the lines manually but I don't want to.
As ever, thanks for looking/replying.