Multi column split value in rows

[spsanu]

Hello All,

I am attaching the dataset in the tab "Data", and we are trying to create output as per the tab "Soluation", we have more than 500 files within the same format to create the same output format.

I am attaching the workflow we are working on where we concatenated all values of different columns in one row and apply the text to the column, the problem is we can pick only one column to split into rows; here, we have only two columns, so it would be easy to apply the select tool and separate the columns; however, in our final data set we have more then 250 columns, it would time taking work if we pick one by one each column then use text to column and again stack on down under.

Kindly let me know if there is any better solution for this.

[DataNath]

Hey @spsanu, you can handle this by adding just a couple of changes to your current workflow...

To your Input Data, you just need to create a 'grouped RecordID', whereby each group i.e. A and B in your data, have unique Record IDs in them. One way of doing this is with the Tile tool like so, where your [Tile_SequenceNum] then acts as this grouped ID:

In your Cross Tab tool, you can now tick this field as a Group By, which will keep records split out rather than concatenating them into a list that you need to re-split:

Now you can just Sort on this to restore the order:

Hope this helps! Have attached the amended flow.

[binuacs]

@spsanu Another way of doing this with the Multi-Row tool