Apologies if this has been asked before but I have searched and only found similar requests, nothing solving my exact issue.
I have some weekly KPI data which gets collated each month into charts. The data is entered each week and totaled using sum formulas onto a sheet. I have a chart...
I have the following sample data.
Using the table on the left, I have manually created the desired table on the right.
It basically transposes the...