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:

company name	company name	company name
xyz cc	rdt pty ltd	ggg cc
contact person	contact person	contact person
john	mel	kevin
tax id	fleet number	profile
1234	44	xxxxxxxx profile

<tbody>
</tbody>

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:

company name	contact person	profile	tax id	fleet number
xyz cc	john		1234
rdt pty ltd	mel			44
ggg cc	kevin	xxxxxxxx profile

<tbody>
</tbody>

hope this helps