How to change the output format of search results?

[gadeanup1]

Using my splunk query, I am getting the output as follows (X and Y are headers)-

X         Y
-----------
1        A
         B
         C
2        A
         B
         C
3        A
         B
         C
4        A
         B
         C

But I need the output in the below format -

X         Y
-----------
1         A
1         B
1         C
2         A
2         B
2         C
3         A
3         B
3         C
4         A
4         B
4         C

I tried using stats, list, and other formatting commands but it didn't work for me.
Can I get any help? Thanks in advance....

[sundareshr · Accepted solution]

I assume your query looks like this (you may have list, instead of values)

base search | stats values(y) as y by x

change this to...

base search | stats values(y) as y by x | mvexpand y

[inventsekar]

Good learnings, Sundaresh Sir.