Forum Discussion
heey
Hello, can I add a column to PIVOT so that it is possible to update free text for each row? And that you will be connected to the same line as soon as I make an update to the DATA BASE?
You could try Power Query.
There is Grouping and Pivoting.
And to add comments you need an extra table with a unique identifier column and a comment column.
The unique identifier must correspond to a column in your "pivot" table.
Then you have to combine "pivot" table with comments table.
It doesn't exactly help me, I set up a PIVOT according to the account PC number that I receive as a report from the priority system, and refresh the data, I want to edit the comments field on the PIVOT, and it will be updated together with the update of the report, and not to reconnect the tables every time .