Expand list of record converting all record elements into column

[montibellin]

I've a table A with an attribute field that must be expanded

every field has different number of record 

and each record has 2 field (name, value)

I'm looking a method that create columns where the header is the value of NAME columns and value of VALUE column is used.
Some NAME values are common to all row of Table A, some Values are different. The differences are limitated. 

the result columns must be:
PersonType, PersonTypeDescription, CREATED ON, USERSTATUS, Legal Employer Name, External Company, Contract Type, Business Unit, Job

[montibellin · Accepted solution]

Solved using "Pivot Column" transform method.

Pivot column: NAME
Values column: VALUE
without aggregation