How to write data from one column of datatable into excel one row and many column?

I have one column of Datatable Like this :
image

How i can write data into excel Like this :
image

*Note : I don’t want to create one by one .

2 Likes

Go through this link
cheers
@thatchakornmua

1 Like

Kindly copy the values and open the excel and Right click it show the “Transpose” options in paste options so you can paste

image

1 Like

Hi @thatchakornmua

Are these static value the Dt_Column and the 5 column below ?

cheers :smiley:

Happy learning :smiley:

2 Likes