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.

​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.  Read More

​