Transposing a single column into multiple columns

csodesza

I am having difficulty in transposing a single column into multiple columns. I am trying to transpose the data in Column E into their own headers. I tried using the cross tab tool but resulting in undesired results when I implement a record ID to each row. Is there an alternative solution to get the desired outcome?

Here is my working file:

Desired result:

sample.xlsx

binu_acs

@csodesza I updated the workflow to reflect Null() value for all the fields 

CrossTab_1019.yxmd