Sort multiple columns to one column, skip blanks

Please see sample below. I have three separate data lists in different columns, and each may have up to 30 names with corresponding number values, or may have no names at all. I want to be able to generate a list in a fourth column that will show all values in the order they originally appeared with their corresponding values to the cells to their right. I have no experience with macros that just run automatically and continuously--if someone could let me know how to set that up that would be much appreciated!

Monkey	5		Mouse	8		Dog	4		Monkey	5
Elephant	10					Gerbil	8		Elephant	10
Rhino	15								Rhino	15
Cat	4								Cat	4
									Mouse	8
									Dog	4
									Gerbil	8

Thanks,
Alex

sorry, posted to wrong thread

Hi msexcelathome, thank you! I have a few questions:

My data start in row 8 of column A, D, and G, and each list has a heading in row 6. I figured out how to change the columns, but when one of my lists doesn't have any data it will copy the heading in, and if there's at least 1 item in the list the heading is not copied. Do you know how I might fix that?

Also, is there an easy way to make this happen as the items are typed in, instead of running the macro?

Thanks,
Alex

Thanks... sorry I got a little confused with my replies.
Alex

MSExcelatHome,

Per your recommendations, I am currently working with the following code, but it continues to make the text in row 6 in a column with nothing entered in its list appear in the final list. Do you know what else I could try changing?

Thanks,
Alex

Please Login or Register  to view this content.