Forum Discussion
Summarising Data
Hi,
I am trying to summarise data from a number of tabs, the data having the same format as reflected below.
I have tried to use Powery Query to summarise in a table format Employee name, type, shift date, Department, Role, Rate and Net Hours but I could not determine how to bring employee name and type into the table? Shift date needs to run down the page as reflected above. If anyoen can help with how to summarise the data this would be great.
Thanks. Matt.
2 Replies
Created a mock-up of what I believe your data looks like. See if the PQ solution in the attached file helps you on your way. If not, come back here and share a link to your file with some realistic data and manually create a table of how you want the end result to be.
Note: I forgot to format the date column!
- Hi Riny, this is great, exactly what I was looking for.
Once you removed the two top rows, which included Empl Name and Empl Type, I thought you would not be able to reflect them again in the table. I will add in the custom column and let you know if I have any further questions. Thanks again Riny.
