Excel Formula or Table question, please have a look as I could not come up with a good title for this post

[neilghuman1]

Below is table number 1.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Manufacturer[/TD]
[TD]Part #[/TD]
[TD]Item Price[/TD]
[TD]Item Shipping[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Neil[/TD]
[TD]1234[/TD]
[TD]50[/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Neil[/TD]
[TD]1234[/TD]
[TD]61[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]4567[/TD]
[TD]30[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]4567[/TD]
[TD]29[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I need the following results.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Manufacturer[/TD]
[TD]part #[/TD]
[TD]Item Price[/TD]
[TD]Item Shipping[/TD]
[TD]Item Price[/TD]
[TD]Item Shipping[/TD]
[/TR]
[TR]
[TD]Neil[/TD]
[TD]1234[/TD]
[TD]50[/TD]
[TD]3[/TD]
[TD]61[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]4567[/TD]
[TD]30[/TD]
[TD]1[/TD]
[TD]29[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Can someone please help me figure out how to get this result as I have over 100,000 records that I need to fix. Thank you and looking forward to your post.

 

[neilghuman1]

Anyone?