Hi,
This should be pretty straight forward, just can't for the life of me work out how to do it.
I've got a list of data in column A that I want to move into a new list but split up so every other cell is blank.
Eg. Cell A2 will be replicated into B2, but cell A3 will replicate in B4 leaving B3 blank.
The data changes on a regular basis so basically want formula that can do this.
Any help could be appreciated
This should be pretty straight forward, just can't for the life of me work out how to do it.
I've got a list of data in column A that I want to move into a new list but split up so every other cell is blank.
Eg. Cell A2 will be replicated into B2, but cell A3 will replicate in B4 leaving B3 blank.
The data changes on a regular basis so basically want formula that can do this.
Any help could be appreciated