•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Power Query - is there a way to combine columns from separate sheets so that rows with the same "name" in a specifed columns always match?
Hi. I am working with a software which exports to values which refer to the same object into separate sheets (e.g. melting and boiling point), but sometimes it does not add correctly so, e.g. in ref1 sheet thing b is in a second row, but in data sheet b is in 3rd row.
Is there way in PQ to combine columns so that it first matches the text in "Name" (they are always in the same column) and then combines rows correctly? There are, however, cases where there is a name in first sheet but there is no match for it in the second sheet
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel alternatives for data analysis
#generative AI for data analysis
#row zero
#google sheets
#financial modeling with spreadsheets
#natural language processing for spreadsheets
#big data management in spreadsheets
#digital transformation in spreadsheet software
#conversational data analysis
#Excel compatibility
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#Excel alternatives
#data analysis tools
#data cleaning solutions
#Power Query