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