How do I stack data in Excel 2007?

[Ana Bosak]

I currently have 4 time periods in column A (rows 1 through 4), and th
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 wit
Columns B through E being the 4 time periods. Cells B2 to E24 would b
the scores. I hope this is a good explanation. This would save me HOUR
of work, as I have to repeat this exercise for 10 regions and man
groups within each region. Thank you so much!



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

+-------------------------------------------------------------------
|Filename: Example Data I need to stack.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=525
+-------------------------------------------------------------------

 

[Don Guillett]

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|

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

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