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


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”