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.