Convert multiple fields in a column into 4 headers

[bmyles]

Hi everyone,

I have a dataset where each item number has 4 rows associated with it, but it needs to be converted into 1. This means each of the 4 attributes associated with that item number should be a header, and the Boolean value should go under that header. 

The image attached shows the transformation that needs to happen more clearly.

Any help would be greatly appreciated. Thanks

[ponraj · Accepted solution]

Here is the solution for your case. Cross tab tool will help you to get you the desired results. 

Sample dataWorkflowResults

[bmyles]

Thank you very much!