I have one sheet that has 100 rows. Column A has numbers ranging from 1 – 9 (each number is used multiple times). Column B has 100 different names.
I then have another sheet that has 9 rows. Column A is numbered 1 -9 (each number only being used once).
I would like to have the names from column B on the first sheet show up across multiple cells in a horizontal fashion on the second sheet (one name per cell) to correspond with the number from column A.
I am using 2010 Excel. Any help would be greatly appreciated. Thank you.