My data looks like this

Name: John
Address: 123 Elm St
City: Anywhere
State: AZ

Name: Sally
Address: 555 Oak St
City: Anywhere
State: AZ

How can I transpose/convert it to a table having the header in row1 and the data beneath
TIA,
Marc