Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

On the left I have the following data from a client, and need to turn into the table on the right. The date columns are dynamic - they vary weekly and the resulting pivot table should react when date columns get added/removed.

If a customer/product has more than one date column with value, the new table should have more than one row to accommodate only one value per row.

enter image description here

share|improve this question
up vote 1 down vote accepted

Actually, it appears that you want to "de-pivot" your data. Here's a situation very similar to yours, with a detailed step-by-step solution:

share|improve this answer

Yes, this is what pivot tables are for, and see here for a tutorial on how to use them. They wrote instructions better than I can.

share|improve this answer

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.