How to transform vertical table into horizontal table?

I have one table Person: Id Name 1Person1 2Person2 3Person3 And I have its child table Profile: Id PersonId FieldNameValue