Help needed for advanced transposing

Hi guys,

I need to 'kind of' transpose a range of data and I have thousands of data cells so I guess a VBA macro would do the trick, however, I'm fairly n00b for that stuff, and I hoped one of you guys could help me out. You can see the attached example in regard to what I'd like to do with data; the input sheet obviously shows the data format I have right now, while the output sheet shows how I'd like data to be. It pretty much resembles a transpose of data, but with a twist though...

(Btw, numbers 1-15 represent my data points, thus they range arbitrarily between empty cells (de facto zero), zero's and several hundred thousands.. hence, don't mind the linearity of the range 1 to 15... that's simply because that was easier to write :-p)


Hope anyone can help - fire away if you need more info! :-)


Best regards,
Niko

Hi John,

Thanks for looking. The numbers in the far left; no1, no2, no3 etc. constitutes the sort :-)


Regards,
Niko

Any help will be greatly appreciated!

In short, what I want to do is a transpose with a twist. I have:

a, 1, 2
b, 5, 6
c, 10,15

and I'd like:
a, 1
a, 2
b, 5
b, 6
c, 10
c, 15

So kind of like a transpose, but keeping the records next to each value - see transpose.xls (input -> output) for more :-)


Regards,
Niko