I need some extra help with transpose..

I saw how to do this:

I have something like this:
A 3 4 7
B 5 2 9 1 5

I need it to look like this:
A 3
A 4
A 7
B 5
B 2
B 9
B 1
B 5

My problem is that I have some extra text before it:

text 1, text 2, A, 3, 4, 7
text 5, text 6, B, 2, 9, 1, 5

I need it to look it like this:

text 1, text 2, A, 3
text 1, text 2, A, 4
text 1, text 2, A, 7
text 5, text 6, B, 2
text 5, text 6, B, 9
text 5, text 6, B, 1
text 5, text 6, B, 5

any help??


--
Raymond75
------------------------------------------------------------------------
Raymond75's Profile: http://www.excelforum.com/member.php...o&userid=30399
View this thread: http://www.excelforum.com/showthread...hreadid=500674