DSXchange

source data :
ColumnA
-----------
111
AAA
222
BBB
333
CCC

Output:
Col1 Col2
111 AAA
222 BBB
333 CCC


I assume we can achieve this with the design

Src-->Txfm (constraint alpha and num functions and generate dummy column with sequence numbers)----> numbers& alphabets------merge--->col1 col2

I am stuck in the sequence generating part because one row goes to 1 o/p and another row to other o/p hence there wouldn't be same dummy key values to merge..Please let me know on this

What is the business rule for this? Is it to pivot strictly on two row increments or is it numeric fields in one column and alpha in second? What happens when its alpha numeric?