I need to take the attached spreadsheet (Raw Data tab) and desired output based on filters (Output tab example).
Dataset with example output: [login to view URL]
No macros, formulas and pivot tables only, please.
Sorting and calculations automatically updates when data gets filtered
All column headers on the final table must be able to have Excel filters/sorting ability
If you need to make a helper tab/table/columns, that is OK
Please be sure to read all of these directions carefully before you bid on the job. I need this delivered within 8 hours of the job starting. I will be asleep for most of the job, so you will need to ask your questions in the first hour.
When you bid, please bid ending in the number one. For example, instead of bidding eleven dollars, bid eleven instead. This will prove to me that you read and understand directions carefully. Please also start your message to me with “Dear Douglas” so that I also know that you can read and understand directions carefully.
I will hire an experienced Freelancer who offers a competitive bid and can deliver in the next 8 hours. Thanks so much and I look forward to hiring you.