How to get different Columns values of datatable into rows of datatablle that is transposing ?

How to get different Columns values of datatable into rows of datatablle that is transposing ? If we dont know the name to columns i.e column names are dynamic only we have one parameter that is columns.suppose datatable contains values

COL1,COL2,COl4…and so on and Output is required to be in format

Output : Col1
Col2
Col4
.
. and so on

Hope this would help you buddy

Cheers @mhk15

yeah sure. but i need changes in datatable only…Iput.xlsx (14.0 KB)

Excel sheet contains both input and desired output

I am sorry. Can’t help you on this but I request others to please share your effective solutions with us.

1 Like