Merge Multiple Columns of Different Lengths With Common Values

I have a longer column (11600 rows) made up of 464 unique values that repeat randomly (Column A of attatchment). I also have eight 465 row columns. I would like to merge the two so that wherever a value appears in column A, the remaining data that should go along with that column is appended to the right of it. For example, wherever APT appears in column A, 3, 2.56, 2, 2.58, 2.61, 0.95, and 554 would appear in columns B-H.

Thank you in advance!

First of all you will need to insert some blank columns from B onwards, so that you do not overwrite the tabular data - I inserted 8 columns, so that the table starts in column K. Then you can have this formula in B1:

=IFERROR(VLOOKUP($A1,$K:$R,COLUMN(),0),"")

and copy across to H1. Then you can copy those formulae down as far as you need to.

Hope this helps.

Pete

Wow, that's an old post that you found !

If you open a workbook that has been set to Manual calculation, then all other workbooks opened in that session of Excel will also be set to Manual, and then when you save them (with that setting) and subsequently open them again, you will have the same problem. However, as you have found, it is easily fixed by changing the Calculation options and saving the file again.

Glad to be able to help. If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete