paneliyadhruv
Member
Dear All,
I have two sheets. Sheet1 having three columns (A to C) and i need to select repeatedly every 1 to 10 till blank and paste it transpose to sheet2 in rows 8 to 10, 13 to 15, 18 to 20 till blank in sheet1 column a to c.
second issue in sheet2 from column A to J row 6 to 7 copy and paste in 11 to 12, 16 to 17, 21 to 22 and so on (i.e. total count of column A sheet1 times).
I have attached file: Sheet1 data and sheet2 required output.
Kindly assist me.
I have two sheets. Sheet1 having three columns (A to C) and i need to select repeatedly every 1 to 10 till blank and paste it transpose to sheet2 in rows 8 to 10, 13 to 15, 18 to 20 till blank in sheet1 column a to c.
second issue in sheet2 from column A to J row 6 to 7 copy and paste in 11 to 12, 16 to 17, 21 to 22 and so on (i.e. total count of column A sheet1 times).
I have attached file: Sheet1 data and sheet2 required output.
Kindly assist me.