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)
In short, what I want to do is a transpose with a twist. I have something like:
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
Hope anyone can help - fire away if you need more info!
Best regards,
Niko