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.
Steven Williams above would have two lines in my file as he has two different pay codes but all his function codes match.
Sheldon Cooper would have only one line in my file
Penny would have two lines
Doylene would have two lines.
I need to have the data in Excel format when I am done for a merge project that occurs next. Any help is greatly appreciated.
2 Replies
Pivot table
Row labels:
ID
Last Name
First Name
Pay Run
Void Manual
Pay Date
Pay Code
Pay Code Descr
Record Type
ASN
Account #
Function
Values
Amount
Report Layout
Tabular
Subtotals
None
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
