I am using Excel 2007. I have a spreadsheet containing many rows. Each rowcontains the columns col1,col2,col3,col4,col5,col6. I want to create two seperate rows for each row. The first row should contain columns col1,col2,col3 and the second row should contain columns col4,col5 and col6. How can I do this in Excel?