Display values in straight table

[prrajendran]

Hi,

i have a table with some product numbers and some other fields displayed in straight table.

i have to display three names consecutively across each product numbers. how will i do this? please help me with the expression

for example , if i have the names John, Abbie, Emma. My output should be like  below:

Product No	Username
30494	John
30677	Abbie
31086	Emma
31742	John
40005	Abbie
40726	Emma
41675	John

[m_woolf · Accepted solution]

Something like:

if(RowNo()/2 = Floor(RowNo()/2).'Abbie'.
       if(RowNo()/3 = Floor(RowNo()/3).'Emma.'John')) as UserName;

[anushree1]

Could you please let me know how the input data will be 

[avinashelite]

Your requirement is not clear , you are wanted to show customers/users for each product rite ? but in the example your product ID is different for all the users ..not user how your data looks like , could you share a sample data set and required output so that we could try to help 

[prrajendran]

Thank you so much