View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] ingve@reslab.no is offline
external usenet poster
 
Posts: 2
Default Split one coloumn into 2 in Excel

Hi,

I have an excel spreadsheet where I have a lot of values in coloumn A.
I want to split this into A and B. ( like a snake )

Coloumn A have: 1000, 1001, 1002, 1003 etc
I want to have A: 1000, B: 1001, A: 1002, B: 1003 etc

Is there an easy way to do this?