Creating Excel sheets from PQ data

[Anonymous]

Hi!

I have a list of users and their offices. I need to split these out and load the list of users from each individual office into seperate Excel sheets. I'm afraid my PQ expertise has hit the buffers!

The list is like this:

Office       User

Brighton   Fred Blogs

Brighton   Bill Smith

Newcastle  William Shakespeare

Manchester  Eric Morecambe

Manchester  Ernie Wise

and so on.....

I want a Excel tab for each of the offices with a list of users and a total number of users for that Office

Can anybody point me in the right direction please?

Thanks.

Ian

[Stachu]

if you need the automation I'd suggest recreating your PowerBI transformations in PowerQuery (or Get&Transform, in the new ones) and automate with VBA

if there are not that many offices you can jut use PowerQuery and create the sheets manually, they will all refresh when you press Refresh All