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.
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