Expand few columns at once - Power Query

[zico8]

Hi,

I transform data in Power Query and now I have some columns that need to be expanded.
Do I have to expand each column singulary or I am able to expand several columns at once (by their name or index)?

 

[Molden]

Hi,

I transform data in Power Query and now I have some columns that need to be expanded.
Do I have to expand each column singulary or I am able to expand several columns at once (by their name or index)?

I have a table called table 2 on sheet6 and used the below to auto adjust the column width:

Sheet6.Range("Table2").EntireColumn.AutoFit

I don't have power query but I imagine the code will be pretty similar

 

[zico8]

That is something totally different !
I do not want to fit column width but expand column with aggregated values.

 

[gazpage]

Expanding All Columns In A Table In Power Query – Chris Webb's BI Blog