text to rows ?

Hi all,
I need help: i have data that contains many variabels in one cell, for example
company A 10-02-2010 5000
23-05-2009 3000
04-04-2009 2000

all variables in each column is in one cell, so there are 3 cells in total in above case for example.
I need this to be changed to this:
company A 10-02-2010 5000
company A 23-05-2009 3000
company A 04-04-2009 2000

with each variables in its own cell so there are 9 cells in total

of course I have data for more than one company

suggestions ?

sample included

thank you !!

is this applicable to larger set of data ?
I actually have much more rows and also more columns then the one in my sample

thank you !!

mmmm, the problem is that I need to do this for many data sets and the number of columns vary. That's why I just post the simplest case
is there easier way to do this beside macro ?

thank you !!

oh yes of course, with such code I could use it with any data set with different number of columns


this is one of the worst case with 14 columns
i still only post 3 rows however, because you said rows dont matter, although in reality i have about 500

also i dont know if this will make it more difficult but sometimes there will be missing data (see the last column), in which case I still need it to be transferred to the new cell but left blank (not deleted or anything. hope this makes sense.

thank you !!

it works perfectly
thank you !!

Hi I actually notice a problem with the code, some of my observations that does not have value are deleted, but I need it to be there with blank cells

sample included, result of applying the code is in sheet 4, deltathree is deleted here, is it possible to modify the code to have it not deleted, but just being there with blanks ??
thank you !!

anyone could help ?
thank you !

another thing I notice is that if the cells contains a number of dates the month and date will be exchanged ? i.e 01/05/1982 will become 05/10/1982 for example
but if the days is larger than 12 since excel will store it as text ? i.e 15/05/1982 will still become 15/05/1982 after I apply the macro but will be stored as text

thank you !!

im having the same problem
anyone can give solution ?

thank you !!!

Interestingly, I used the code today in another computer and it still gives inconsistent month and date for each date that have value above 12
I was pretty sure that I get the correct result when I was working from home yesterday

is this a bug in excel or something ?