Changing Column data to rows

[jaxmudd]

Hi everyone,

I was given a data set that listed header fields in a column format. I need to extract the data and make them rows so I can do a data comparison against another data set.

Example.
Name Jayme
date 032315
id 5
state IL

I want it to look like
Name Date ID State
Jayme 032315 5 IL

Any Ideas? Transpose did not work for this.

 

[gaz_chops]

Transpose seems to work

[TABLE="width: 455"]
<tbody>[TR]
[TD="width: 65"]Name[/TD]
[TD="width: 65"]Jayme[/TD]
[TD="width: 65"][/TD]
[TD="width: 65"]Name[/TD]
[TD="width: 65"]date[/TD]
[TD="width: 65"]id[/TD]
[TD="width: 65"]state[/TD]
[/TR]
[TR]
[TD]date[/TD]
[TD="align: right"]32315[/TD]
[TD][/TD]
[TD]Jayme[/TD]
[TD="align: right"]32315[/TD]
[TD="align: right"]5[/TD]
[TD]IL[/TD]
[/TR]
[TR]
[TD]id[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]state[/TD]
[TD]IL[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]