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:

Name	Country	Sector	Industry
KOLWEZI	Nigeria	Financials	Mortgage
KUMASI	Ethiopia	Materials	Construction
SOKOTTO	Nigeria	Financials	Insurance

<tbody>
</tbody>

What I want:

Name	Country	Sector	Industry	Priority	Action Item	Person	Date
KOLWEZI	Nigeria	Financials	Mortgage Finance	High	Present to IC	JH	29-Apr
High	Finalize financial	SC	31-May
Medium	Prepare dataroom	CC	10-May
KUMASI	Ethiopia	Materials	Construction	High	Present to IC	SC	29-Apr
High	Finalize financial	SC	31-May
Medium	Prepare dataroom	JH	10-May
SOKOTTO	Nigeria	Financials	Insurance	High	Present to IC	SC	29-Apr
High	Finalize financial	SC	31-May
Medium	Prepare dataroom	CC	10-May

<tbody>
</tbody>

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.