Hello,

I have data something like this

ID Line code
100   1    v120
100   2    v130   
100   3    v14
100   4    v123
100   5    v11
100   6    v6

I want the data to be displayed like this

ID Code1 code2 code3 code4 code5 cod6
100 v120 v130 v14   v123 v11   v6

I grouped it by ID and used following formulas to display

@code1: if line = 1 then code
@code2: if line = 2 then code
@code3: if line = 3 then code

I only see the data for code1 and data is null n code2 & code3

I am not sure where it went wrong could someone please assist me.

THanks.