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?
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.
- I found another way to do this, through the PIVOT
You cannot add text values to a pivot table, and if you enter them in a column next to the pivot table, they won't move with the rows of the pivot table.
