How to split 1 column value into 2 columns

[SheetalB]

Hi,

I need help in column splitting, please find test cast

I am getting below table data

Sr. No	Reasons
1	Reason1
2	Reason2

I want output as below

1st Reasons	2nd Reasons
Reason1	Reason2

Thanks,

Sheetal

[here2h3lp]

Try the function CROSSTABLE