Hi Folks,
G'day!

I come here to seek a solution to a problem I am facing.

My requirement is as follows:
I create a pivot table and then add remarks in front of the table I create. Screenshot attached:
Screenshot 2024-11-17 at 10.15.25 AM.png

Whenever I update the data and refresh the Pivot Table, the rows shift, leading to inconsistency. Screenshot attached, where yellow highlights the rows corresponding to the remarks. Screenshot attached.

Screenshot 2024-11-17 at 10.52.08 AM.png

Is there a way, where the remarks can be tied to the respective rows of the Pivot Table? This is a sample data and I have hundreds of categories for which I need the remarks to be tied.

Any help would be appreciated.

Thank you
Varun