Expand multiple columns from xml file

[eddd83]

How do I expand multiple columns at once? There are many more columns (that need expansion) than what is shown in the picture below. 

[eddd83 · Accepted solution]

I figured out how to do it. 

This blog explains it much better than I could: https://blog.crossjoin.co.uk/2014/05/21/expanding-all-columns-in-a-table-in-power-query/

[themistoklis]

@eddd83 

Have you tried selecting all tables and then clicking the 'expand' icon?

Never tried it myself.

IMage below:

[eddd83]

For this scenario, if I have selected multiple columns and then I click the expand icon next to the "category" column, it will deselect all columns and only select the "category" column. Then I can only expand the category column.