Lookup + Text To Column + Transpose/Crosstab

[Pulkitkhattar]

Hi,

Could anyone please help with the situation I'm stuck in.

Attached is the sample data having input, lookup data and required output.

Please let me know if further information is required.

Kindly help me with same.

Thanks

[Pulkitkhattar]

InputLookup Reference