Convert Horizontal datatable to Vertical datatable

Want to convert into Vertical datatable

Hi @Bhushan_Nagaonkar

You can refer the below video for better understanding on converting from horizontal datatable to Vertical.

Hope it helps!!

Im getting error for dt_result can you tell me variable type for this?

@Bhushan_Nagaonkar

dt_result datatype is datatable

In my case I just need data from first five columns just before “form 1099div subtotal”. Is there a way to do it and get the output in the way mentioned above.

@Bhushan_Nagaonkar

extract all the rows

and you can skip unwanted rows

before using the above method,Use the below code after extracting the data

Dt.asenumerable.take(5).copytodatatable

1 Like

In my excel due to extract cv my column starts from B

dt_result is the datatable datatype. @Bhushan_Nagaonkar

I got it right this time. My question will I be able write those column in new sheet on specified column with my accordance

1 Like