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:

[binuacs]

@csodesza One way of doing this

[acarter881]

Hello, @csodesza. I believe the attached workflow is what you're describing.

Spoiler

[csodesza]

Thank you for the swift response. I noticed the values of these new fields are being mapped to 'PID'. How would I transpose without mapping to any of the data shown here?

[csodesza]

Here's an updated sample. Thanks for all your help!

[csodesza]

Thank you for the swift response. I noticed the values of these new fields are being mapped to 'PID'. How would I transpose without mapping to any of the data shown here?

Attached is the updated sample

[binuacs · Accepted solution]

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

[csodesza]

Thanks that did the trick! Appreciate your help on this 😁