Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
3  
Maybe this question will help. –  Mike Fitzpatrick Jul 23 '12 at 12:49
1  
And along the lines of Mike's answer, see spreadsheetpage.com/index.php/tip/… –  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
add comment

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.