Pivot Table

New Contributor

I would like to convert my pivot table to a normal excel table so it will be possible to make changes. Thanks a lot for your help!!

7 Replies

Hi @Bettyna 

 

just copy the Pivot table and paste it as values in an empty area:

Martin_Weiss_0-1667924370821.png

Martin_Weiss_1-1667924382489.png

 

 

 

@martin

 

Hi Martin,
thank you very much for your intention to help.

I have already done just that, unfortunately it didn't work. the formatting stayed the same and you can't delete lines, columns or make changes.

Best regards,

Bettyna

@Bettyna 

Try pasting into a range that overlaps neither with the rows nor with the columns of the pivot table, or paste into a different sheet.

Don't forget to paste as Values or as Values and Number Formatting.

Thanks a lot Hans, unfortunately, despite having followed the instructions, the data in the date column is still in the same wrong format. Thanks anyway for your support! and nothing happens when trying to change the format of this column:
2022-10-03 UBS L023 6236 0 1191533
2022-10-03 UBS L023 6236 0 1191624
2022-10-03 UBS L023 6236 0 1193382
2022-10-03 UBS L023 6236 0 1197963
2022-10-03 UBS L023 6236 0 1198878
2022-10-03 UBS L023 6236 0 1198878
2022-10-03 UBS L023 6236 0 1199318
2022-10-03 UBS L023 6236 0 1199556

Thanks again!
Best regards,
Bettyna

@Bettyna 

Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

to which mailaddress should I send you the sample workbook? I tried to atacht it here but it is not possible

@Bettyna 

You can attach it to a private message to me (click on my user picture)