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 nam...
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.
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.