Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I need to create a new sheet in the existing excel sheet using Power Query in Excel, wherein only the names without corresponding GSTIN entries are displayed automatically.
For example:
Name | GSTIN |
Sophia | 24HDS2000ZOM1 |
Max | |
William | |
Layla | 24HDS2000ZOM1 |
I want to display the above name without the GSTIN in new sheet using excel power query
I thought your question was "how do I keep only names that have no values as the corresponding GSTIN. If so, you can just import the table into Power Query, and then in the GSTIN column, right click it on a null or empty value, and choose "Equals". This will give you all rows where the GSTIN is blank. Then just load to an Excel sheet.
--Nate
Hi @Manushi_16,
But remember, @lbendlin mentioned importat thing on purpose: Power Query can not create new sheet everytime you load new data. It'll just update existing query in existing sheet where you loaded it for the first time.
Hi @Manushi_16,
Yes you can.
In excel you convert this data as table and go through query from a table in Data tab. You can do necessary transformation in power query (split by delimiter and so on) and when you finish, you can either directly clase the query and it will create a new sheet and load as a new table in a new sheet.
Every time you refresh, that new sheet will be refreshed.
Power Query has no idea what a "sheet" is. It's just a query. You need to then take the results of the query and place them somewhere, in a sheet for example.