Excel - need items in a row to be Column Headers

Hello,

I have attached a Test data set. I am trying to figure out how to get the values listed in the "Header" column to be listed as separate columns.

Output that I'm trying to achieve - columns:

Input

Output

Apps

Help

Preparation

In Database

Expression

In-Database

Accepted answers

Just a simple cross tab tool with the following setup

Sounds like a Cross Tab tool!

Just a simple cross tab tool with the following setup

@bradaba33 if my solution was useful, you can also accept mine as a solution (especially since it was the same and first)! Thank you in advance