Straight Table for Records

[rishikeshtiwari]

Dear All,

I am facing an issue.I have a table of 5 fields.

Here I want to a straight table .

Table:  Recors for ID

           Records according for ID.

I tried but Record column is blank>please help.

[amit_saini]

Rishi,

For this kind of data , pivot table is preferred .Kindly see the attachment.

Thanks,

AS

[#3 · Accepted solution]

Dear Rishi,

Please see file attached. All you needed was an expression.

Regards

R