convert field values into columns Straight.T

[CreoLTD112]

Hi.

Im Fairly new to Cliq and coding, just wanted to find out..

I have created a straight table containing the following fields

Modified by|Client|Time|Category|Value etc..

values running below the column Category are e.g: 1,2,3,4 

I would like to know how can i these fields from running vertically to horizontally as individual fields e.g:

Modified by|Client|Time|1|2|3|

any advise or assistance would be highly appreciated, and i do not want to do this with a pivot table, preferably changes made within expressions? just not sure how

Thanks

[CreoLTD112]

Hi, turns out i incorrectly named my naming convention e.g: Category should of been category- lower case c, which worked perfectly..thanks guys

[CreoLTD112]

Hi, turns out i incorrectly named my naming convention e.g Category should of been category- lower case c, which worked perfectly..thanks guys