Openoffice macro column to row

Need to create a macro that will add rows by combining content of 2 columns Ex Column 1 column 2 column3 column4 Product Type Size 1 Size 2 Pants apparel S 38 T-shirt apparel M 39 Polo apparel L 40 Sneakers shoes XL XXL From the table above, I need to have a row by size, the size depending on the type of clothe. OUPUT Column 1 Column 2 Product size Pants S Pants M Pants L Pants XL Pants 2XL T-shirt S T-shirt M T-shirt L T-shirt XL T-shirt 2XL Sneakers 38 Sneakers 39 Sneakers 40