I am having one column as 'A' and that column is having data in string such as 'abcdefgh 1.01.11,mnopqr 2.01.09' so i want to separate the value in two columns as 'B' which will contain values as 'abcdefgh' and 'mnopqr' and column 'A' will contain '1.01.11' and '2.01.09'.
So i am using cross table to show the column values and it is getting displayed as,
B abcdefgh
B mnopqr
A 1.01.11
A 2.01.09
So I want to display the value in the cross table in this format how should i do?
B abcdefgh
A 1.01.11
B mnopqr
A 2.01.09