How do I take one row of data in Excel and split it into multiple rows?
Given this input:
Name Award Type 1 Amount 1 Award Type 2 Amount 2 Dan Top Performer $5,000 Top Region $10,000 Kathy Rep Planmaker $2,500
I want to convert it to this:
Name Award Type Amount Dan Top Performer $5,000 Dan Top Region $10,000 Kathy Rep Planmaker $2,500
In words: since the “Dan” row in the input data shows two awards – one in columns B&C and another in columns D&E – I want to split Dan’s data into two rows, one for each award.