I am trying to take a fairly extensive set of Data in Excel and format it in more of a list view. I was thinking a Pivot Table may help me with this but I have ZERO experience with Pivot Tables and wanted to see if there may be an experienced member that may be willing to take a look at my file and help me out.
@Ayman Hassan My problem is that I need to include the rows, the columns and all of the data in between and turn it into a report style. I am not positive that a Pivot Table will even do this for me - it was just my first idea.
I have attached the file.
I would ultimately like to filter it by date (weekly), job name and then the technician but I am running into a roadblock as to how to make that happen.