I have the following data in Excel:

and would like end up with something resembling the below:

There is quite a large amount of data to manipulate so I seek the most efecient way of doing this, in essence it would involve:

- Searching column
`Region`

for`-`

- If found, grab data from start of
`-`

till next instance of`-`

or`end of cell`

- Copy data into new row with accompanying extended data (as per the second screenshot)
- Loop

Please let me know if further information is required and thank you in advance

Raw data below:

```
Current:
State Region Type Frequency Region Time Selected Medians and Averages Value
New South Wales Statistical Area Level 2 Annual Eden 2011 Median age of persons 47
New South Wales Statistical Area Level 2 Annual Eurobodalla Hinterland 2011 Median age of persons 48
New South Wales Statistical Area Level 2 Annual Merimbula - Tura Beach - Moss Beach 2011 Median age of persons 51
New South Wales Statistical Area Level 2 Annual Moruya - Tuross Head 2011 Median age of persons 50
Proposed:
State Region Type Frequency Region Time Selected Medians and Averages Value
New South Wales Statistical Area Level 2 Annual Eden 2011 Median age of persons 47
New South Wales Statistical Area Level 2 Annual Eurobodalla Hinterland 2011 Median age of persons 48
New South Wales Statistical Area Level 2 Annual Merimbula 2011 Median age of persons 51
New South Wales Statistical Area Level 2 Annual Tura Beach 2011 Median age of persons 51
New South Wales Statistical Area Level 2 Annual Moss Beach 2011 Median age of persons 51
New South Wales Statistical Area Level 2 Annual Moruya 2011 Median age of persons 50
New South Wales Statistical Area Level 2 Annual Tuross Head 2011 Median age of persons 50
```