Hi,

I don't have experience on programming but need following kind of excel macro so any help is greatly appreciated.

I need to copy data organized like below from one excel sheet:

apple one two
banana one two three
orange one

to another sheet like this:
apple one
apple two
banana one
banana two
banana three
orange one