Help Unpivoting table?

[Pauklzorz]

Hi all,

I'm using Excel 2011 on a Mac, I have the Developer tab available.
I have a workbook that looks like this:


[TABLE="width: 850"]
<colgroup><col width="50" span="17" style="width: 50pt;"></colgroup><tbody>[TR]
[TD="class: xl63, width: 50"]Family[/TD]
[TD="class: xl63, width: 50"]Genus[/TD]
[TD="class: xl63, width: 50"]Species[/TD]
[TD="class: xl63, width: 50"]Blood / Heart[/TD]
[TD="class: xl63, width: 50"]Teeth / Mouth[/TD]
[TD="class: xl63, width: 50"]Guts / Stomach[/TD]
[TD="class: xl63, width: 50"]Sexual health[/TD]
[TD="class: xl63, width: 50"]Neurological[/TD]
[TD="class: xl63, width: 50"]General[/TD]
[TD="class: xl63, width: 50"]Eyes[/TD]
[TD="class: xl63, width: 50"]Muscles/Skeleton[/TD]
[TD="class: xl63, width: 50"]Skin[/TD]
[TD="class: xl63, width: 50"]Wounds and cuts[/TD]
[TD="class: xl63, width: 50"]Other[/TD]
[TD="class: xl63, width: 50"]Throat Nose Ear[/TD]
[TD="class: xl63, width: 50"]Lungs / Breathing[/TD]
[TD="class: xl63, width: 50"]Urinary[/TD]
[/TR]
[TR]
[TD="class: xl63"]Nymphaeaceae[/TD]
[TD="class: xl63"]Nymphaea[/TD]
[TD="class: xl63"]alba[/TD]
[TD="class: xl63"]Staunch bleeding (Cavan)[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"]A cure for corns (Argylshire), drawing a boil (Cavan)[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[/TR]
</tbody>[/TABLE]



I want it to be transformed to this format:
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Family[/TD]
[TD]Genus[/TD]
[TD]Species[/TD]
[TD]Use Category[/TD]
[TD]Details[/TD]
[/TR]
[TR]
[TD]Nymphaeaceae[/TD]
[TD]Nymphaea[/TD]
[TD]alba[/TD]
[TD]Blood / Heart[/TD]
[TD]Staunch bleeding (Cavan)[/TD]
[/TR]
[TR]
[TD]Nymphaeaceae[/TD]
[TD]Nymphaea[/TD]
[TD]alba[/TD]
[TD]Teeth / Mouth[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Nymphaeaceae[/TD]
[TD]Nymphaea[/TD]
[TD]alba[/TD]
[TD]Guts / Stomach[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Nymphaeaceae[/TD]
[TD]Nymphaea[/TD]
[TD]alba[/TD]
[TD]Sexual Health[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Nymphaeaceae[/TD]
[TD]Nymphaea[/TD]
[TD]alba[/TD]
[TD]Neurological[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Nymphaeaceae[/TD]
[TD]Nymphaea[/TD]
[TD]alba[/TD]
[TD]General[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]














And so forth.

I know that the way to do this in using the developer tabs, and creating a macro, I found some things similar on this forum, but I don't really understand visual basic at all. Can anyone help?
Thanks ahead!<style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:1.0in .75in 1.0in .75in; mso-header-margin:.5in; mso-footer-margin:.5in;}td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignoreadding; color:black; font-size:12.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;}.xl63 {border:.5pt solid windowtext;}--></style><style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:1.0in .75in 1.0in .75in; mso-header-margin:.5in; mso-footer-margin:.5in;}td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignoreadding; color:black; font-size:12.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;}.xl63 {border:.5pt solid windowtext;}--></style>