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!

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))