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??
Bookmarks