cross tab to flat file VBA

[Speed boy]

Keep getting close, just not quite yet. I have the following cross tab table that I would like to convert to a flat file. (pivot table ready)

The labels that begin w/ > will not contain data, but will be needed as metric labels for the data below each one. As long as I keep these headings out of the data I have multiple code scenarios that do work. These sub headings are throwing me a curve.

Jan Feb Mar Apr May Jun
>Exposure(measure label)
Twitter Impressions 25 55 45 65 75 85
Total Twitter Followers 100 125 145 165 200 212
>Influence (measure label)
Average Klout Score 45 48 50 45 35 25
Site Visits from Influencers 120 145 155 165 155 145
>Engagement (measure label)
Retweets
Mentions
Hashtag Mentions
Twitter Website Visits Organic
Twitter Website Visits Campaign
Twitter Blog Visits Organic
Twitter Blog Visits Campaign
Link Clicks
>Conversion (measure label)


Post conversion cross tab to flat file:

>Exposure Twitter Impressions Jan 25
>Exposure Twitter Impressions Feb 55
>Exposure Twitter Impressions Mar 45
>Exposure Twitter Impressions Apr 65
>Exposure Twitter Impressions May 75
>Exposure Twitter Impressions Jun 85
>Exposure Total Twitter Followers Jan 100
>Exposure Total Twitter Followers Feb 125

and so on...

Appreciate the feedback as usual, Speed Boy