.
Swarnendu

No problem.

Its alot easier to understand the goal from your side because everything is there for you to see.
Sometimes it takes a few exchanges to fully understand what the goal is.

From the workbook mdmackillop posted it is easier to understand the goal. However, I don't understand why the column of data in J changes when it is pasted to the next blank column.
What have I missed ? Shouldn't the data remain the same when it is copied from J and pasted to the next blank column ?

Why is the data changing ?