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 anyone please let me know the code for this as I've hunted and can't find.
Many thanks
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 anyone please let me know the code for this as I've hunted and can't find.
Many thanks