Hi
I wanted to copy a column from one sheet and transpose it to another in merged cells but could not get the code to work.
So, I thought instead I would get the destination row to take the cell value twice.
I.e.
Source Data
abc1
abc2
abc3
Destination Data
abc1 abc1 abc2 abc2 abc3 abc3
Can...