Thread: text to ROW macro

hi
I've seen text to column but no text to row function in excel

I am fairly used to vb [vb6] but am a n00b at macros or office programing etc.

I have a large workbook. each sheet contains afew coumns of descriptive part data and the last column contains designators eg c1, c2 & jp1, jp3, jp5 etc
so a typicall row would be
100017 FINAL ASSY,MIRROR ENPC36A 9010001 5 CAP,SMD,1206,.01uF,50V,20%,X7R C2,C7,C8,C16,C5

I need to be able to split the last column of designators out into rows each of which would then hold one designator and the same data for the rest of the columns
eg
100017 FINAL ASSY,MIRROR ENPC36A 9010001 5 CAP,SMD,1206,.01uF,50V,20%,X7R C2
100017 FINAL ASSY,MIRROR ENPC36A 9010001 5 CAP,SMD,1206,.01uF,50V,20%,X7R C7
100017 FINAL ASSY,MIRROR ENPC36A 9010001 5 CAP,SMD,1206,.01uF,50V,20%,X7R C8
.
.
and so on.
I know this is prob more involved than a to column function, but if anybody could even point me in the right direction or get me started would be much appreciated cos dont really know where to start.
thanks in advance

Please can specify how are divided column because you used ',' and it seems each designator is collocated in a different column.

Do u really have data separated in columns how you indicated with comma?

If it's so I think for each row a macro have to read data from right to left and when find a column that doesn't start with 'C' that is the last column of data to repeat in all the rows... is it correct?

Regards,
Antonio

thanks for your quik reply antoka05, but I have actually found one that will do the same job for me.
i would copy it here, but its internally created and Im not sure how the high and mighty's stand on such things.
thank you very much anyhoo