I have a csv format report showing user transactions during periods where the system didn't translate clockin information from a secondary payroll system.
This captures tens of thousands of rows of data, but I need to condense it by the username start time of the first transaction for that user and end time of the last transaction.
Format is
A. B. C. D. E.
Username|noncritical_system_entry|miscellaneous_data|start_date_time|end_date_time
Is there a way to search this data to leave only one entry per day per username with first start and last end transaction time; to make it more manageable to input clockin and clockout to ensure these users get credit for their system transactions?
The only values I need to keep are columns A D and E
Thanks in advance,
Shaman
Bookmarks