Transform Column1 to ColumnHeaders

Hi -- this feels like a very basic transformation issue but for the life of me I cannot figure out the proper steps of getting to my desired table. Any help is much appreciated! 

ORIGINAL TABLE

Column1 Column2

Full Name Abayan, Mark

Loan Release Date 11/21/2024

Loan Amount 4000

Loan Type Salary Loan

Loan Purpose Sent to parents

Full Name Dacanay, Jeffrey

Loan Release Date 11/25/2024

Loan Amount 1000

Loan Type Cash Advance

Loan Purpose Cash Advance

Full Name Flores, Joan

Loan Release Date 11/28/2024

Loan Amount 500

Loan Type Cash Advance

Loan Purpose null

TARGET RESULT TABLE

Full Name Loan Release Date Loan Amount Loan Type Loan Purpose

Abayan, Mark 11/21/2024 4000 Salary Loan Sent to parents

Dacanay, Jeffrey 11/25/2024 1000 Cash Advance Cash Advance

Flores, Joan 11/28/2024 500 Cash Advance null

Cheers,

David