•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Dynamic Merge in Power Query
In my Power Query I merged these columns with another table.
Now I need to do a dynamic Merge, for example particularly with the Qualification tab there are 7 qualifications that are there in the other table from where this is getting merged, now if there is only one qualification that needs to changed we can put in this table and it will work accordingly, but on a certain day if there is 7 qualifications, how to ensure that I will leave the qualifications column blank and all the qualifications will be pulled through as in merged,
This is the Table where the qualifications and details will be mentioned.
this is the merged criteria in case it helps.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#Power Query
#Dynamic Merge
#Qualifications
#Merging
#Table
#Columns
#Merged Criteria
#Data Transformation
#Details
#Dynamic
#Qualification Tab
#Blank Column
#Validation