Sol KawageFeb 27
#help do I know any #excel wizards? I have a simple-ish problem and no idea how to solve it, but I suspect it's very easy if you know how:
I have several sheets with code lists on one column and quantities on the other, and I need to merge them into one sheet with the first column of codes, and then the quantities from each of the other sheets in columns.
The caveat is that the code lists in each sheet list might not be 100% the same.
Show threadDan Kletter 🥑Feb 27
@sol Power Query to combine (it’s like a cross join) everything in the workbook. Any time you add data to the sheets or a new sheet, it will automatically update the combined output. https://www.youtube.com/watch?v=zxNq2mISfIc
Combine Multiple Excel Sheets with a Transform Sample Sheet in Power Query

YouTube
Show threadSol Kawage
@soundclamp oooohhhhh THANK YOU! wizard has come forth :)
Feb 27 at 3:04pmWeb
Show threadDan Kletter 🥑Feb 27
@sol Oh yeah, of course!