Forum Discussion
Excel Formula Assistance
I am receiving an excel file with thousands of rows of data in it like this: I need to end up with an Excel file that has one line per employee for each individual pay code or function. ...
You may be able to use remove duplicates (on the Data Tab) and only leave ticked the 3 columns you care about
If this is something that needs to be done regularly then Excel's Power Query functionality is perfect for automating this sort of thing