Combinin Columns

[Susana Conklin via OfficeKB.com]

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!

 

[Frank Kabel]

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