Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
AbhishekGandhi23
Contributor II
Contributor II

Cross Table

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

Labels (3)
0 Replies