•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