Cross Tab

[itahir04]

Hi Team,

I need assistance in Cross tab.

I have fields with multiple values in a column. I've transposed them, cleaned them. How do I put them together now?

Attached file has one tab for test data, and other with desired out put.

Please assist me.
Thanks,

Rana

[itahir04]

 Thanks for all who helped me with this thread.

Regards,

Rana

[itahir04]

HI @ponraj,

You have great logic but you it is little complicated for me. 

Thanks for your response.

Regards,

Rana