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.
Bernd
Posted 2012-07-23T12:10:32.270
Reputation: 333
1
Possible duplicate of How to "unpivot" or "reverse pivot" in Excel?
– Raystafarian – 2018-04-18T22:28:20.9873
Maybe this question will help.
– Mike Fitzpatrick – 2012-07-23T12:49:51.2371
And along the lines of Mike's answer, see http://spreadsheetpage.com/index.php/tip/creating_a_database_table_from_a_summary_table/
– F106dart – 2012-07-23T13:58:35.9571Why not import the data into Microsoft Access and define a query to pull out the data you need? – wbeard52 – 2012-07-23T18:44:05.430