1

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.

Sathyajith Bhat
  • 61,504
  • 38
  • 179
  • 264
Bernd
  • 333
  • 6
  • 10
  • 3
    Maybe [this question](http://superuser.com/questions/78439/is-it-possible-to-unpivot-or-reverse-pivot-in-excel) will help. – Mike Fitzpatrick Jul 23 '12 at 12:49
  • 1
    And along the lines of Mike's answer, see http://spreadsheetpage.com/index.php/tip/creating_a_database_table_from_a_summary_table/ – F106dart Jul 23 '12 at 13:58
  • 1
    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
  • 1
    Possible duplicate of [How to "unpivot" or "reverse pivot" in Excel?](https://superuser.com/questions/78439/how-to-unpivot-or-reverse-pivot-in-excel) – Raystafarian Apr 18 '18 at 22:28

0 Answers0