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!
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

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>
 

Forum statistics

Threads
1,144,099
Messages
5,722,476
Members
422,437
Latest member
BDodge

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top