Datatable formatting and outputting to Excel

Hi Guys!

So i have data like this:

21425 1234567890 1 Logan 3232313123 1 Logan 1454214214 1 Logan
21420 9876543210 1 Logan 8201337453 1 Logan 7711755962 1 Logan
23000 7711451976 1 Logan 8201337453 1 Logan 7711755962 1 Logan
20000 7711451976 1 Logan 8201337453 1 Logan 7711755962 1 Logan
20010 7711451976 1 Logan 8201337453 1 Logan 7711755962 1 Logan
21900 7711451976 1 Logan 8201337453 1 Logan 7711755962 1 Logan
21800 7711451976 1 Logan 8201337453 1 Logan 7711755962 1 Logan
20200 7711451976 1 Logan 8201337453 1 Logan 7711755962 1 Logan

And i want to have it outputted like this:

21425
1234567890 1 Logan
3232313123 1 Logan
1454214214 1 Logan
21420
9876543210 1 Logan
8201337453 1 Logan
7711755962 1 Logan
23000
7711451976 1 Logan
8201337453 1 Logan
7711755962 1 Logan

How should i do it? Do we need to output dt and split it to string first?

-Mikko-

do you mean you want an excel file that looks like that?

Sorry my bad! Actually it must be like this. All in A1 column in Excel…

21425
1234567890
1
Logan
3232313123
1
Logan
1454214214
1
Logan
21420
9876543210
1
Logan
8201337453
1
Logan
7711755962
1
Logan
23000
7711451976
1
Logan
8201337453
1
Logan
7711755962
1
Logan

im afraid to ask what you will do with this :rofl: but you have output data table activity and after see if it works for you, if not do some string replace until it does.

haha. It is gonna go to AS400 terminal. That is why it must be in each row format… :smiley:

1 Like