Data Formula

Hi there, I am using excel and need some assistance. I have 2 columns of data. The first column is a list of countries and the second column is a list of cities. There are multiple entries of the same country in column one because there are multiple cities in column 2. I would like to take the information in column 2 and transfer it multiple cells across one line against the country. Can this be done?

By: Tony McGraw

Leave a Reply

Your email address will not be published. Required fields are marked *