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:
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?
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
Proud to be a Datanaut!
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!