Forum Discussion
Solved
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 Powe...
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.
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/uks2zkbH9AJj
Please look this sample. https://file.io/uks2zkbH9AJj
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.
- Still cant recreate. But! I've copied your table to my project, reassign its source to another table and it works! So thats great. Thanx a lot