Extract data in each column to rows in new worksheet

[jee10]

Hi. I have a spreadsheet with company details in a worksheet. Each company details are in a new column. Like the following example:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]company name[/TD]
[TD]company name[/TD]
[TD]company name
[/TD]
[/TR]
[TR]
[TD]xyz cc[/TD]
[TD]rdt pty ltd[/TD]
[TD]ggg cc[/TD]
[/TR]
[TR]
[TD]contact person[/TD]
[TD]contact person
[/TD]
[TD]contact person
[/TD]
[/TR]
[TR]
[TD]john[/TD]
[TD]mel[/TD]
[TD]kevin[/TD]
[/TR]
[TR]
[TD]tax id[/TD]
[TD]fleet number
[/TD]
[TD]profile[/TD]
[/TR]
[TR]
[TD]1234[/TD]
[TD]44[/TD]
[TD]xxxxxxxx profile[/TD]
[/TR]
</tbody>[/TABLE]

i basically need each of the bold heading in the first row of the new worksheet. Each company details will then need to be moved into a new row with the corresponding data under the correct heading column. Not all the companies have all the data for each heading it would be fine to have "none" value or blank in this case

Any ideas on how to do this

 

[Oeldere]

Please show the desired (expected) result.

 

[jee10]

Please show the desired (expected) result.

I would like the new worksheet to look like this:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]company name
[/TD]
[TD]contact person
[/TD]
[TD]profile
[/TD]
[TD]tax id
[/TD]
[TD]fleet number
[/TD]
[/TR]
[TR]
[TD]xyz cc
[/TD]
[TD]john
[/TD]
[TD][/TD]
[TD]1234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]rdt pty ltd
[/TD]
[TD]mel
[/TD]
[TD][/TD]
[TD][/TD]
[TD]44
[/TD]
[/TR]
[TR]
[TD]ggg cc
[/TD]
[TD]kevin
[/TD]
[TD]xxxxxxxx profile
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

hope this helps