split datatable column using c#

Jaimin H Soni

Hi i want to split column into multiple columns using c#. Ex. 100 rows in COLUMN_A , convert into COLUMN_A1(Firt 20 records) COLUMN_A2(next 20 records) COLUMN_A3(next 20 records) COLUMN_A4(next 20 records) COLUMN_A5(next 20 records) is it posiblie?

Lost User

Jaimin H Soni wrote:

is it posiblie?

Yes, simply read it row by row and stuff the contents in a column. That'd be assuming that a "row" could fit in a single "column". Can you show an example row?

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

Jaimin H Soni

I have datatable that have one column in that 112 rows and i want to convert like that col1 20 rows (1 to 20) col2 20 rows (21 to 40) col3 20 rows (41 to 60) col4 20 rows (61 to 80) col5 20 rows (81 to 100) col6 20 rows (100 to 112)

Lost User

Then you'd have to add some columns to the datatable, and loop the records.

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

Jaimin H Soni

I tried looping but i cannot get exactly what i want...

Lost User

Show us your code :)

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]