Transpose Field values

[qv11user]

Hi Team,

Hope all are doing good!

I have a column called Part Number which contains numbers like below

Part Number
-----------
P1,P2,P3,P4,P5,P6

But I need output of column as like below

Part Number
----------
P1
P2
P3
P4
P5
P6

I need to implement this in the Front-end (Not in the script level).

Can you please help me to achieve this?

Stay Safe!

Regards,

QV User

[sunny_talwar]

Which object do you want to view this in? Text box object? straight table?

[qv11user]

Hi Sunny,

Thanks for your response.

I need to implement this in Straight table.

Regards,

QV user

[sunny_talwar]

So, basically you want to use it as a dimension? Are there other dimensions? I would suggest to convert it into script, otherwise you will be complicating your chart way to much.