How to add similar rows in excel sheets

  • Thread starter Thread starter Dinesh
  • Start date Start date
D

Dinesh

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.
 
For better answers, think you need to explain the logic
how your source data (as posted) "gets" into the sample results:
AGR DEL IC
AGR DEL IT
AGR DEL 9W
AGR DEL S2
Click to expand...

Example:
Where is IC, IT, 9W, S2 ?
And how are these associated with AGR DEL ? etc

---
 
Back
Top