Stacking multiple columns into 2 columns - against a reference point

[pupppish]

Hi there, hoping someone can help me sort out a poorly formatted data-set which I've inherited and need to clean up to create some reports.

In short, the data-set extends out from column A to column A0, and has 435 rows.

Each row shows a unique 'case number' and then against each case number are pairs of tags of 'themes' and 'specific points', set out horizontally (see below - I've only added 3 pairs of tags for reference). In some cases there's only one pair of theme/specific point tags, whereas in others there are up to 20.

Rather than having these tag pairings extending out horizontally against the case number, I'd like to have them all stacked into two columns against their relevant case number.

So rather than it looking like this, as it does now:

Row 1	Case number	1. Theme	1. Specific Point	2. Theme	2. Specific Point	3. Theme	3. Specific Point
Row 2	00012	Cost	Too expensive	Engineering	Most viable route
Row 3	00016	Socio-Economic	Supports growth	Cost	Public spend	Transport	Improves connectivity
Row 4	00019	Engineering	Shorter Route
Row 5	00056	Cost	Too expensive
Row 6	00058	Transport	Improve journey time	Cost	Too expensive

<tbody>
</tbody>

I'd like it to look like this:

Row 1	Case number	Theme	Specific Point
Row 2	00012	Cost	Too expensive
Row 3	00012	Engineering	Most viable route
Row 4	00016	Socio-Economic	Cost
Row 5	00016	Cost	Public spend
Row 6	00016	Transport	Improves connectivity
Row 7	00019	Engineering	Shorter route
Row 8	00056	Cost	Too expensive
Row 9	00058	Transport	Improve journey time
Row 10	00058	Cost	Too expensive

<tbody>
</tbody>

Appreciate any help with this!

 

[pupppish]

*Sorry, Row 4 for the proposed layout should instead read:

Row 4

00016

Socio-Economic

Supports Growth

<tbody>
</tbody>

 

[pupppish]

Bump