Combinin Columns
 

I have an entire database of info that looks like:

colum one =99213 column two= 10.00 column three= 99213 column four- 11.00;

how do I make a table that shows:
column one= 99213 coulmn to= 10.00 column three= 11.00

Note that column three has more information in it so the rows do not excaly match across for all..

help!

--
Message posted via http://www.officekb.com

Hi
not completely sure but try:
- insert a new column C (column 3)
- in C1 enter
=IF(COUNTIF($D$1:$D$100,A1),VLOOKUP(A1,$D$1:$E$100 ,2,0),"")
and copy this down

Afterwards copy column C and insert it again with 'Edit - Paste
Special - values' to remove the formulas

--
Regards
Frank Kabel
Frankfurt, Germany

"Susana Conklin via OfficeKB.com" schrieb im
Newsbeitrag ...
I have an entire database of info that looks like:

colum one =99213 column two= 10.00 column three= 99213 column four-
11.00;

how do I make a table that shows:
column one= 99213 coulmn to= 10.00 column three= 11.00

Note that column three has more information in it so the rows do not
excaly match across for all..

help!

--
Message posted via http://www.officekb.com