Well, you have to merge/join the table somehow. Do you want to match them based on observation number...? Some kind of Id column generally is the best/common way to do it.
About the multiplying part: you have to convert your character column to numeric first by using the input function: