bbqpringles
New Member
- Joined
- Sep 23, 2015
- Messages
- 25
So, I'm sure there is an easy answer to this, but for some reason I can't seem to find how to hide column(s) in Power Query.
I'm pulling from an existing Excel workbook to create a query, but when I'm in the editor and right-click on the column, there is no option to hide the column. I also don't see anything in the ribbon that would allow me to hide the column in the editor. I've included a link to an evernote file that shows what is available when I right-click on the column header.
I'm totally green with Power Query, but hoping that I can use it to automate some monotonous data formatting tasks on reports I pull weekly/bi-weekly...
Thanks in advance for the help!
I'm pulling from an existing Excel workbook to create a query, but when I'm in the editor and right-click on the column, there is no option to hide the column. I also don't see anything in the ribbon that would allow me to hide the column in the editor. I've included a link to an evernote file that shows what is available when I right-click on the column header.
I'm totally green with Power Query, but hoping that I can use it to automate some monotonous data formatting tasks on reports I pull weekly/bi-weekly...
Thanks in advance for the help!