Joining lists from 3 columns

**simonhall** · 10-28-2007, 09:32 PM

Hi,

I have three lists in separate columns that I wish to join together as 1 list in a fourth column. ie the fourth column will contain entries from list in column A, then entries from column B, then entries from Column C, going down the pages so it forms one long list.

The catch becomes the lists in the first 3 columns vary in length, as they are populated using an index and match function.

Please see attached file. Please note this is sample data only.

How do I go about generating the list I require.

Thanks, Simon

**Paul** · 10-28-2007, 10:40 PM

Hello simonhall,

The following code is based on your example:

Please Login or Register  to view this content.

This code loops through column D and inserts the values from that column into column I, starting in row 1. It then moves to columns E and F, performing the same function.

I added an If/Then to check to see if it is copying the header from column D, E or F, and if so make that cell in column I bold.

Let me know how that works for you.

**simonhall** · 10-28-2007, 10:44 PM

Hi Paul,

I can see that this would work.

However, is it possible to achieve the same thing using formulas without using the VBA code?

Thanks, Simon

**Paul** · 10-28-2007, 10:57 PM

There very well could be a way to do it using worksheet formulas, but it probably wouldn't be pretty.

Is there something wrong with using VBA? I'll see what I can find about merging uneven columns using worksheet functions, but I can't promise anything. Also, you wouldn't be able to bold the header cells using functions.