Forum Discussion

Bettyna's avatar
Bettyna
Copper Contributor
Nov 07, 2022

Pivot Table

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

excel

7 Replies

  • Bettyna's avatar
    Bettyna
    Copper Contributor
    Nov 08, 2022

    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

    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Nov 08, 2022

      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.

      • Bettyna's avatar
        Bettyna
        Copper Contributor
        Nov 14, 2022
        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

Resources