复制并粘贴，但插入行并转置一些行

I have in a spreadsheet detail of orders I wish need to convert into a different format. The data come across for example: Customer Order date Product Order no Line no Desc 1 Desc 2 Desc 3 B & Q 10 January Ladder 1 1 Step ladder Grey Short B & Q 11 January Paint 1 2 Outdoor Matt Green Tesco 8 January Food 2 1 Picnic food Party JanI have in a spreadsheet detail of orders I wish