Transform record to columns

Istwineres

Hi all, I'm looking for a solution to transform records in columns. My desidered output would be a column for each element on code column and group by value's record

value    PERF365_ITD_N    Perf_MTD_N  ...... bmk    bmkpef

  xyz        0.380054                 -0.01811             bmk1   -0.00037

Many thanks!

test_crt.xlsx

mceleavey

Hi @Istwineres ,

this is a simple crosstab function:

I've attached the workflow.

M.

Crosstab.yxmd