Reordering cells to another sheet

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

Hi
are the different values in adjacent columns, (A1 = Apples, B1 = one etc) or all on one cell

Hi,
Different values are in adjacent colums (A1=apple, B1=one, C1=two)

Excellent! Thousand thanks!!

Hi,

I marked this existing thread as unsolved because now it appears that I need also the outcoming values to be presented in adjacent columns but given macro combines values in same cell.

So is it possible to modify the macro in a way that also output is in this format:
A1=apple B1=one
A2=apple B2=two

Awesome! Thank you so much Mike!

Mikko