Hello ! Can anyone help on how to paste link and transpose data at the same time? Let me give more details: I have a set of data in row in sheet1 and in sheet 2 of the same workbook, I have replicated data from Sheet1 but they are organized in column (instead of row). When copied data in shett 1...