Forum Discussion
gmu18
Mar 07, 2019Copper Contributor
Is it possible to make a query automatically create new rows out of specific columns?
Hello, I am trying to create a query that automatically hides questions based on their answer. My end goal is to have the query to pull a file from my C drive as soon as I download it and automa...
JKPieterse
Mar 07, 2019Silver Contributor
PowerQuery is there alright, it is on the Data tab and they stupidly called it "Get & Transform".
gmu18
Mar 07, 2019Copper Contributor
I meant to say the tab "Power Query" isn't there. I have been using the query via the Data tab, but I can't figure out how to create the new rows through the query.
- JKPieterseMar 08, 2019Silver ContributorI know, there won't be a powerquery tab in 2016, as it is integrated into the data tab.