Nov 11 2021 01:27 PM
Hello,
I was wondering if someone can give me an idea or help me understand How I Can join the tables with slightly different format. please check the attached screenshot tables.png for tables and result.png for the required output.
Thanks in advance
Nov 12 2021 12:40 AM
@DEEPAKSAVANUR Connect to both tables with PowerQuery. Before you can merge the two, you need to split the first column of Table2 into rows, using " & " (i.e. space & space) as the delimiter.
Then you can merge the two based on ID and expand the RATING. Result attached.