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?
9 Replies
No, pivot tables don't work that way, sorry.
- Hey thanks .
Is there a way to overcome this?
I process data derived from the priority and it is necessary to add comments to the linesYou 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.
