Hello. May somebody help me with how to do this in Power Query. I'm using Excel 2016.
I have the following 2 input tables.
<tbody>
TABLE 1
TABLE 2
DESCRIPTION
VALUE
PREFIX
CODE
ID
0
7235
ABX1
NAME
JFMSC
3553
POWQ
TYPE
UHELQ
7459
UWEER
DFRUL
F4
10012
ABX1...