chrisguk
Board Regular
- Joined
- Jan 10, 2011
- Messages
- 135
Hi there,
I created a pivot table in the normal from my source data in tabular format. For example;
My rows are Accounts & Sites
My columns are dates
My Values are Consumption values in sum format
I copied this pivot table and pasted the values in a different work sheet then proceeded to work on the gaps. I have a problem though, I forgot to add supplier to the rows too.
Is there a way to put my pivot in values back to the raw data tabular format easily?
I created a pivot table in the normal from my source data in tabular format. For example;
My rows are Accounts & Sites
My columns are dates
My Values are Consumption values in sum format
I copied this pivot table and pasted the values in a different work sheet then proceeded to work on the gaps. I have a problem though, I forgot to add supplier to the rows too.
Is there a way to put my pivot in values back to the raw data tabular format easily?
