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

I am facing the task of querying about 20 parties for numerical data. I will do this via an Excel template. The Excel file is a table with a x (2...51) and a y (B...M) dimension. Data is to be filled in for each (x, y) pair.

For evaluation, I would like to unroll the two-dimensional tables into a one-dimensional list, duplicating all y-items plus corresponding data for each x-item. Kind of "un-pivotizing" the tables. Is there an automatic way of doing this in Excel?

I cannot distribute the one-dimensional list version as this will not be accepted by my peers due to bad usability.

Ultimately, I want to consolidate the data and evaluate it with my own pivot table.

share|improve this question
Maybe this question will help. – Mike Fitzpatrick Jul 23 '12 at 12:49
And along the lines of Mike's answer, see… – F106dart Jul 23 '12 at 13:58
Why not import the data into Microsoft Access and define a query to pull out the data you need? – wbeard52 Jul 23 '12 at 18:44

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.