Forum Discussion
How to make a pivot table same as source
Hi. I have a source table which have a fixed number of columns and dynamic number of rows. I have to make a copy of this table to another sheet which will be just the same as source. I have used Power Query and smart tables before and everything was worked like a charm. But now I need to adopt it for older versions of Excel (2010-2013) - so I cant use Power Query because it was not a part of 2013 office and required additional installation. Of course It can be done by using formulas for each cell but this is not suitible for me. So the only way I see here is using of Pivot table. But I cant understand how to make just the same table without any calculations, totals, sumtotals, groupings, controls etc.
Please help.
I have attached sample file with sample dataset, the goal to make a copy of the source table to the Sheet2 using pivot table. https://file.io/C5uil8jXDFWK
RigganT202 don't know how you created the PT in sheet3 as it did not show the column headers. Created a new one from scratch in Sheet4.
4 Replies
RigganT202 It doesn't seem to be a very meaningful way to do this but I trust you have a good reason for it. Perhaps the attached file does what you ask for.
It involves pulling all columns from the data table into the row area of a pivot table and then do quite a bit of formatting (tabular, repeating labels, no sub- or grand totals and fix the dates).
See attached.
- Hi. Thank you very much!. Yes its just what I needed. I have converted the source table to the smart table to make it dynamic and played with firmatting, But when I've tryed to recreate another table just the same as yours, I've failed. Can you please look at the Sheet3 and point my mistakes. What I'm doing wrong? Why all data is in one column?. I have compared nearly every parameter of your pivot table but couldnt get same result.
Please look this sample. https://file.io/uks2zkbH9AJjRigganT202 don't know how you created the PT in sheet3 as it did not show the column headers. Created a new one from scratch in Sheet4.
