View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Dinesh Dinesh is offline
external usenet poster
 
Posts: 103
Default How to add similar rows in excel sheets

I have a data
AGR DEL
AGR JAI
AGX BLR
AGX COK
AJL CCU
AJL GAU
AJL IMF
AMD BHO
AMD BLR
AMD BOM
AMD CCU
AMD CJB
AMD DEL
AMD GOI
AMD HYD
AMD IDR
AMD IXY
AMD JAI
AMD JLR
AMD MAA
AMD NAG
AMD PNQ
AMD RPR
AMD STV
ATQ DEL
I want to make it like

AGR DEL IC
AGR DEL IT
AGR DEL 9W
AGR DEL S2

how can i do this?

Please help me to do so ur urgent help will be appreciated.