Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

How do I take one row of data in excel and split it into multiple rows?

Take this: Name Award Type 1 Amount 1 Award Type 2 Award 2 Dan Top Performer $5,000 Top Region $10,000 Kathy Rep Planmaker $2,500

Convert to this:
Name Award Type Amount
Dan Top Performer $5,000
Dan Top Region $10,000
Kathy Rep Planmaker $2,500

share|improve this question
Please edit your question to show cells you already have, and cells you would like. –  DaveP Jul 30 '12 at 15:37
add comment

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.