Hello,

I was recommended this site by a friend, so im hoping someone can help me!

Hoping my title was clear, not sure exactly how to solve my little problem..

Heres what im trying to achieve, I have the following template xsl...

A 1 2 3
B 1 2
C 1 2 3 4
D 1 2 3 4 5
E 1 2 3

I want to try to turn this data with the use of formulas/macros into....

A 1
A 2
A 3
B 1
B 2
C 1....etc...


Considering that the number of entries per letter is different and so are the number themselves, i dont know where to start!

Any ideas of which formula or even macro processes to use? Perhaps I am better of import the data into a database and creating a report?

Any help would be appreciated!

Thanks!