how to stop auto show query table at refreshing

[aboly8000]

[FONT=&quot]hi​
I'm trying to get a few columns hidden with my worksheet using Power Query.[/FONT]
[FONT=&quot]I've tried hiding the columns like you would do normally in Excel, but every time I refresh the query the columns automatically unhide.[/FONT]
[FONT=&quot]What can I do to prevent the Columns from unhiding. [/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]Thanks[/FONT]

 

[sandy666]

as I said before
- Close&Load to...
- Connection only
then
- Insert
- Pivot Table
- Use an external data source
- Choose connection
- select your Query Table
- Open
- select destination place
- OK

 

[aboly8000]

thank you very match

 

[sandy666]

you are welcome

next time post your question about PowerQuery in a proper forum

have a nice day

 

[aboly8000]

Hello
Is there any other way than power query to combine multiple columns of a table and get a report in pivottable?...

 

[sandy666]

the question is too general

what does that mean: combine multiple columns?
what you want to achieve before PivotTable?

 

[sandy666]

maybe look at: https://contexturesblog.com/archives/2016/08/18/quick-ways-unpivot-excel-data/

 

[aboly8000]

the question is too general

what does that mean: combine multiple columns?
what you want to achieve before PivotTable?

I have some columns of names in the data table and I want to combine them into one column and report by pivottable and make one slicer of the names.

 

[sandy666]

see post#16

but I can't help with vba or formula