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
|