View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sang sang is offline
external usenet poster
 
Posts: 2
Default How to cross-multiply text data in excel??

I need to cross-multiply following dat:

COLUMNS:
A........................B

ABC...................PQR
BBC...................LMN
KBC...................KKP

The result should be:

COLUMNS:
A........................B

ABC...................PQR
ABC...................LMN
ABC...................KKP
BBC...................PQR
BBC...................LMN
BBC...................KKP
KBC...................PQR
KBC...................LMN
KBC...................KKP

plz help