Firstly, apologies if this is in the incorrect section.
I don't have any examples to hand, but I will try to explain.
Our datasheet contains about 1000 rows. The first column "ID" contains a unique code for this company. This is a repeating value, as in, rows 20-30 could have the same ID and 40-50.
I threw this into a pivot table to only show one ID and then the columns to go with it. Works great.
The problem is now that the bosses want this pivot table on a word document. Not only that but the document would need to change for all 60 unique ID numbers.
So I have two options.
Manually paste in the pivot table 60 times in 60 different documents, changing the ID in the pivot table each time.
Or hopefully find a way to automate this process.
We are using O365.
I can't get my mind how to get power query to show only one ID per row and then the other columns spread out over the rows as well. I've tried unpivot, pivot.
Any help is really appreciated.
Bookmarks