How do I stack data in Excel 2007?
 

I currently have 4 time periods in column A (rows 1 through 4), and the scores for Questions 1 through 23 in columns B through X (same 4 rows). I need to end up with Column A stating Question 1-23 (23 rows), and with Columns B through E being the 4 time periods. Cells B2 to E24 would be the scores. I hope this is a good explanation. This would save me HOURS of work, as I have to repeat this exercise for 10 regions and many groups within each region. Thank you so much!



I have attached an example (I only show up to Q10 to save space). THANK YOU!

How do I stack data in Excel 2007?
 

On Tuesday, August 7, 2012 8:04:59 AM UTC-5, Ana Bosak wrote:
I currently have 4 time periods in column A (rows 1 through 4), and the

scores for Questions 1 through 23 in columns B through X (same 4 rows).

I need to end up with Column A stating Question 1-23 (23 rows), and with

Columns B through E being the 4 time periods. Cells B2 to E24 would be

the scores. I hope this is a good explanation. This would save me HOURS

of work, as I have to repeat this exercise for 10 regions and many

groups within each region. Thank you so much!







I have attached an example (I only show up to Q10 to save space). THANK

YOU!





+-------------------------------------------------------------------+

|Filename: Example Data I need to stack.zip |

|Download: http://www.excelbanter.com/attachment.php?attachmentid=525|

+-------------------------------------------------------------------+







--

Ana Bosak

in cell b4 copied across and then down
=INDEX($A$12:$E$25,COLUMN(B1),MATCH($A4,$12:$12))