muhleebbin
Active Member
- Joined
- Sep 30, 2017
- Messages
- 252
- Office Version
- 365
- 2019
- 2016
- 2013
- 2010
- Platform
- Windows
- MacOS
- Mobile
- Web
Can someone assist in helping me turn a .csv export into something usable?
Currently the export has the following column headers:
Within the Date column, there are names of our employees. For example row 2 is the employees name (rest of row is blank) and then rows 3-7 are date values and subsequent entries in the rest of the columns. The number of rows does vary employee by employee because they could be doing work for multiple jobs in a day. I'm trying to add a column a on sheet2 so that it brings in the employee name and then the rest of the values to create a pivot table.
Ultimately what i'm trying to do is find a specific Cost Code (PTO) under each employee, so if there's another way to look up under the rows of each employee the cost code PTO without doing the first ask, that would be most helpful!
Currently the export has the following column headers:
Date | Job | Time In | Time Out | Cost Code | Hours | Earn Code | Phase | Status |
Within the Date column, there are names of our employees. For example row 2 is the employees name (rest of row is blank) and then rows 3-7 are date values and subsequent entries in the rest of the columns. The number of rows does vary employee by employee because they could be doing work for multiple jobs in a day. I'm trying to add a column a on sheet2 so that it brings in the employee name and then the rest of the values to create a pivot table.
Ultimately what i'm trying to do is find a specific Cost Code (PTO) under each employee, so if there's another way to look up under the rows of each employee the cost code PTO without doing the first ask, that would be most helpful!