Create row as per column count

I think you want to use the Pivot snap to convert the percentage data. You can then use a Join on the two datasets and a mapper to do the calculation.

I’m attaching a pipeline that demonstrates this approach:

RowAsPerColumn_2019_04_16.slp (10.9 KB)