Data Transpose row to column

[Udesheyy]

Hello,

I have to automate an excel sheet. In the excel sheet I need to transpose row to column.

Total 10 23 25 13 13

Transpose this row to column.

Total
10
23
25
13
13
Like this.
Can anyone please advise me on this.

Thank you.

[artshoque (Yuriy Tymkiv)]

Hello,

Looks like your question related to this answer: How to transpose row to column in datatable?

[Srini84 (Srinivas Kadamati)]

@Udesheyy

Check attached for your reference

DataTableTranspose.zip (8.9 KB)

Hope this may help you

Thanks

[ppr (Peter Preuss)]

find a sample for a LINQ approach here:

find starter help here:
Transpose_Demo_LINQ.xaml (8.9 KB)

[Udesheyy]

@Srini84
Thank you so much. It’s worked.