The rows returned in excel is single and it should be multiple

Hi,

I have a report to create in Excel using BI Publisher which it should return multiple rows.

For example,

I have a report that was group by a number

number 1

a

b

c

number 2

a

b

number 3

a

b

c

d

But when I tried the repeating group and highlight the cell that will coverage the repeating group and group it by number, I got

number 1

a

number 2

a

number 3

a

Can someone help me what to do?

Thanks in advance,

Lawrence