Power Query Challenge 44: Combine Tables with Different Column Titles

[@sandipsoni4047]

Very useful thanks for sharing this valueable tips

[@PowerMquery]

You are welcome

[@IvanCortinas_ES]

Very compact solution, Omid. Thanks for sharing.

[@PowerMquery]

You are welcome

[@Excelambda]

Great video!! Great PQ solution !!
As alternative, this is how simple it is if we have in our portfolio unpivot lambdas:
=LET(a,VSTACK(UP(C3:F6),UP(C9:G12),UP(C15:F18)),PIVOTBY(INDEX(a,,1),INDEX(a,,2),INDEX(a,,3),SUM,,0,,0))
where UP (UnPivot) :
=LAMBDA(a,LET(w,ROWS(a)-1,l,COLUMNS(a)-1,s,SEQUENCE(w*l),HSTACK(INDEX(DROP(TAKE(a,,1),1),QUOTIENT(s-1,l)+1),INDEX(DROP(TAKE(a,1),,1),MOD(s-1,l)+1),TOCOL(DROP(a,1,1)))))

[@PowerMquery]

Thanks for sharing your solution

[@ajayrathod7777]

Nice video,Does Value.Metadata referencing to intermediate steps reduce query loading time?

[@PowerMquery]

Not actually, Power Query does not run the step in the defined order and pick the optimum order and neglect those are not requieres

[@moisesgonga1302]

First comment 😂🎉🎉🎉

[@PowerMquery]

Thanks