Change list data

  • Thread starter Thread starter Daveo
  • Start date Start date
D

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
 
Fill down the columns C and D as far as you need:

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