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],

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

Hi Ali thank you so much for responding. I've attached a redacted copy of the actual spreadsheet with comments and a tab with a mock up. Really really...

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

I'm just down the road from you!!!

Can you please mock up a few rows of data showing how you want it to look?...

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

hi i have an energy readings spreadhseet populated by ms forms responses. i need to get the meters as rows and then the monthly readings as columns to...