Need to merge two files based on condition

Question

Hi Team,

@Qiu  @AkimasaKajitani

I have attached input as well as the expected output here.

My concern is, I have input 1 sheet with data like AAAABBBBCCCC,DDDD,LLLLMMMM and input 2 sheet like AAAA=24,BBBB=87,CCCC=44,DDDD=79,LLLL=64,MMMM=81. So my expected output is

AAAABBBBCCCC24*87*44

DDDD79LLLLMMMM64*81

Please help me on this

Sorry friends. Previously attached wrong file.

Now I have a correct file.

Please help me on this

Test file.xlsx

Qiu · Accepted Answer

@Gsiva3

Honestly, not fully get your logic and just tried to get output as same as you provided.

Qiu · Accepted Answer

@Gsiva3

Please dont do that ...  or you can accept my last as well😁

Anyway,