Stacking multiple columns into 2 columns - against a reference point

pupppish

New Member
Joined
Mar 20, 2019
Messages
3
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 1Case number1. Theme1. Specific Point2. Theme2. Specific Point3. Theme3. Specific Point
Row 200012CostToo expensiveEngineeringMost viable route
Row 300016Socio-EconomicSupports growthCostPublic spendTransportImproves connectivity
Row 400019EngineeringShorter Route
Row 500056CostToo expensive
Row 600058TransportImprove journey timeCostToo expensive

<tbody>
</tbody>


I'd like it to look like this:

Row 1Case numberThemeSpecific Point
Row 200012CostToo expensive
Row 300012EngineeringMost viable route
Row 400016Socio-EconomicCost
Row 500016CostPublic spend
Row 600016TransportImproves connectivity
Row 700019EngineeringShorter route
Row 800056CostToo expensive
Row 900058TransportImprove journey time
Row 1000058CostToo expensive

<tbody>
</tbody>

Appreciate any help with this!
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

pupppish

New Member
Joined
Mar 20, 2019
Messages
3
*Sorry, Row 4 for the proposed layout should instead read:
Row 400016Socio-EconomicSupports Growth

<tbody>
</tbody>
 

Watch MrExcel Video

Forum statistics

Threads
1,109,204
Messages
5,527,396
Members
409,759
Latest member
KCH

This Week's Hot Topics

Top