how to put information on CSV size quantity in a row

anyone knows how can put size q'ty on CSV ?



like size :S 10q'ty size: M 11q'ty



on csv



i know combination has that function —csv combination



but it has to put separate row in csv



A B C D

product code combiantion amount

1 1122 s 10

2 1122 m 11

3 1122 l 2

4 1122 xl 0





so…anyone knows this make as one row? on csv



that is spend time to put same product code 1,2,3,4 , so i want make as one row.



please help me

have you tried copy> paste special> “transpose”