Spitting a single row into multiple rows in a Database

[philippickard]

Hi,

Would be great if someone could help me with the below request:

I have a a large database of about 200 rows. I am looking to split individual rows into additional rows without changing the preceding cells.

The below is an example:


What I have:[TABLE="width: 328"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Country[/TD]
[TD] Sector[/TD]
[TD]Industry[/TD]
[/TR]
[TR]
[TD]KOLWEZI[/TD]
[TD]Nigeria[/TD]
[TD]Financials[/TD]
[TD]Mortgage[/TD]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[TD]KUMASI[/TD]
[TD]Ethiopia[/TD]
[TD]Materials[/TD]
[TD]Construction[/TD]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[TD]SOKOTTO[/TD]
[TD]Nigeria[/TD]
[TD]Financials[/TD]
[TD]Insurance[/TD]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
</tbody>[/TABLE]

What I want:


[TABLE="width: 623"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Country[/TD]
[TD]Sector[/TD]
[TD]Industry[/TD]
[TD]Priority[/TD]
[TD]Action Item[/TD]
[TD]Person[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD]KOLWEZI[/TD]
[TD]Nigeria[/TD]
[TD]Financials[/TD]
[TD]Mortgage Finance[/TD]
[TD]High[/TD]
[TD]Present to IC[/TD]
[TD]JH[/TD]
[TD]29-Apr[/TD]
[/TR]
[TR]
[TD]High[/TD]
[TD]Finalize financial[/TD]
[TD]SC[/TD]
[TD]31-May[/TD]
[/TR]
[TR]
[TD]Medium[/TD]
[TD]Prepare dataroom[/TD]
[TD]CC[/TD]
[TD]10-May[/TD]
[/TR]
[TR]
[TD]KUMASI[/TD]
[TD]Ethiopia[/TD]
[TD]Materials[/TD]
[TD]Construction[/TD]
[TD]High[/TD]
[TD]Present to IC[/TD]
[TD]SC[/TD]
[TD]29-Apr[/TD]
[/TR]
[TR]
[TD]High[/TD]
[TD]Finalize financial[/TD]
[TD]SC[/TD]
[TD]31-May[/TD]
[/TR]
[TR]
[TD]Medium[/TD]
[TD]Prepare dataroom[/TD]
[TD]JH[/TD]
[TD]10-May[/TD]
[/TR]
[TR]
[TD]SOKOTTO[/TD]
[TD]Nigeria[/TD]
[TD]Financials[/TD]
[TD]Insurance[/TD]
[TD]High[/TD]
[TD]Present to IC[/TD]
[TD]SC[/TD]
[TD]29-Apr[/TD]
[/TR]
[TR]
[TD]High[/TD]
[TD]Finalize financial[/TD]
[TD]SC[/TD]
[TD]31-May[/TD]
[/TR]
[TR]
[TD]Medium[/TD]
[TD]Prepare dataroom[/TD]
[TD]CC[/TD]
[TD]10-May[/TD]
[/TR]
</tbody>[/TABLE]




I am able to do this manually my inserting columns and merging the preceding cells, my database if however to big to repeat this exercise over and over. I require the rows to be separate as the Action Item will be exported to a different sheet and ordered by priority, and the same time referencing the came and country.

Thank you in advance.