Hi everyone,
I am trying to match key value pairs based on the attached dataset. For every cell we are trying to match a key value from list first from the right and then from the underneath of that cell.
Lets say for example we take cell A9: see file sss
For the final table essentially, we need to have 2 rows for every cell.
Many thanks in advance
@Ibryam_Ibryam
I can not connect the image sample with your sample dataset.
Can you elaborate a bit more?
This information seems incomplete please attach the expected out and some more explanation.