I have a Pivot Table (columns 1 and 2), and I also have manually inserted data (columns 3 and 4):
But when more data gets added to the pivot table, the manually entered columns won't follow "their" row, so the rows become misaligned like this:
I would need the table to behave so that when new data gets added to the pivot table, the manually inserted rows keep up with "their" row, like this:
I've looked around, tried to make it work, but couldn't find anything. Any help?