I want to transpose column to row and also concatenate values by semicolon separated. Here is example. I can transpose column values for first 2 rows but how can I build 3rd column from rest of the rows?
P.S: I built empty dataTable to have column names in OutputDT.
@Palaniyappan: Can you also help me achieving required output?
Thanks & Regards,