How to separate values from one cell to separate cells

[rajeswarir]

I have created a table using search as mentioned below,

S.No TestCycle ResponseTime ElapsedTime
1 TC1 12 15
32 11
13 26
21 34
2 TC2 35 61
22 72
33 14
15 45
For me the Test Cycle result Response Time & Elapsed Time is displaying in single cell but i want it to split each value in single cell as mentioned below
S.No TestCycle ResponseTime ElapsedTime
1 TC1 12 15
2 TC1 32 11
3 TC1 13 26
4 TC1 21 34
5 TC2 35 61
6 TC2 22 72
7 TC2 33 14
8 TC2 15 45

[niketn]

@rajeswarir , what is your current query which gives table 1 as per your question? Do you have multi-value response which is currently being returned in Response Time field?

[rajeswarir]

Yes i am getting multiple response being returned in ResponseTime & ElapsedTime