Forum Discussion
convert from single column to multiple columns
I have an list of addresses in one column Name1 Adress1 Postcode1 City1 Name2 Adress2 Postcode2 City2 Name3 Adress3 Postcode3 City3 Name4 Adress4 Postcode4 City4 Which must be...
Hi,
As variant:
- if your initial list in column A:A,
- add index column (let say C) where starting from C1 it will be numbers 1,2,3,..
- in D1 add formula
=OFFSET($A$1,($C1-1)*4+0,0)
in E1
=OFFSET($A$1,($C1-1)*4+1,0)
and simular to F1 and G1 (using ..*4+2 and ...*4+3)
- copy cells from D1 to G1 down