Showing results for 
Search instead for 
Did you mean: 
ianw1000 Regular Visitor
Regular Visitor

Creating Excel sheets from PQ data


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?



Stachu Super Contributor
Super Contributor

Re: Creating Excel sheets from PQ data

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

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Helpful resources

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Top Kudoed Authors
Users Online
Currently online: 253 members 2,618 guests
Please welcome our newest community members: