changing horizontal data to be shown vertically

For example,

I have information that appears like this:

Q1 Q2 Q3 Q4
2008 5 10 2 3
2009 6 8 12 14
2010 3 5 2 9

I need the information to be shown as

2008 Q1 2008 Q2 2008 Q3 2008 Q4 2009 Q1 2009 Q2 2009 Q3 2009 Q4 etc...


Is there a formula that will move the information to move cells so it is shown this way?

U can use this formula:

Please Login or Register  to view this content.

Refer the attached file.

Let me know if it worked for you.

Regards,
Karan

Thanks Karan! This is very helpful. I now have one more piece to the puzzle. I have attached the example. If there is more than one group of (2008-2010) Data, how can i get the formula to recognize the correct person's name?

Originally Posted by karan

U can use this formula:

Please Login or Register  to view this content.

Refer the attached file.

Let me know if it worked for you.

Regards,
Karan