Change list data

[Daveo]

Hi there,

Is there a way of quickly turning some data in this format:

A B
Name Name1
Address Address1
Name Name2
Address Address2
Name Name3
Address Address3

Into this format:

A B
Name Address
Name1 Address1
Name2 Address2
Name3 Address3


Thanks in advance anyone - David

 

[Bucky]

Fill down the columns C and D as far as you need:

C = INDIRECT("B" & ROW()*2-1)
D = INDIRECT("B" & ROW()*2)

 

[Daveo]

Thanks Bucky - David