Thread: Split one coloumn into 2 in Excel
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
MartinW MartinW is offline
external usenet poster
  
Posts: 860
Default Split one coloumn into 2 in Excel
Hi,

Try this

Place this in B1
=INDEX(A:A,ROWS($1:1)*2-1)
Place this in C1
=INDEX(A:A,ROWS($1:1)*2)

Highlight both cells and drag down as far as you need.

HTH
Martin


Reply With QuoteReply With Quote