AliGW thats fantastic!!
i have a couple of questions
See if this PowerQuery solution suits your needs.
M Code:
let Source = Excel.CurrentWorkbook(){[Name="TBLREADINGS"]}[Content],
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...
rantanwang Today, 08:38 AMI'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?
Just on my way out, but will respond to all three questions when I get back later this afternoon.
...
AliGW Today, 11:50 AM