can a pivot table show my data in the way i need it?

Thank you so much, figured out how to load into editor and added extra columns to calculate consumption and am now creating a dashboard with slicers....

can a pivot table show my data in the way i need it?

Well, of course it depends, but as your master workbook must contain TBLREADINGS, it should be as easy as creating a blank query and copying in my code....

can a pivot table show my data in the way i need it?

Just on my way out, but will respond to all three questions when I get back later this afternoon. ...

can a pivot table show my data in the way i need it?

AliGW thats fantastic!!

i have a couple of questions

1. how do i add the code to the master spreadsheet
2. easiest way to have blank

can a pivot table show my data in the way i need it?

See if this PowerQuery solution suits your needs.

M Code:

let
    Source = Excel.CurrentWorkbook(){[Name="TBLREADINGS"]}[Content],