Lookup question

[Manjari]

Hi All,

Requesting help on the below look up question. 

I tried using text to columns and then mapping them separately, but I do not know how many columns the text to column tools to split. in the below example the first row is 3 next is 5 next one can be 10. Is there a robust way to do this. 

I have a Data set 

Data set

A;B;C

F;G;H;J;K

L;M;N

M;J

E;

D;

I have a lookup table 

Lookup Value	Look up array
A	Apple
B	Basket
C	Chocolate
D	Denmark
E	Elephant
F	Friday
G	Goat
H	Hitler
I	India
J	Jerry
K	Kite
L	Lemon
M	Mango
N	Name

I want my output to be like:

Output

Apple;Basket;Chocolate

Friday;Goat;Hitler;Jerry;Kite

Lemon;Mango;Name

Mango;Jerry

Elephant;

Denmark;

[PeterA1 · Accepted solution]

Hey @Manjari ,

Parsing to rows usually does the trick with a record id added! 

Please see attached and let me know if this answers your question

[Manjari]

Thank you @PE_dup_233 this worked like a charm 🙂