How to Combine Lists into One Dynamic Excel List

Microsoft Excel Tips and Tricks

In this tutorial, you’ll learn how to quickly combine multiple lists in Excel into one dynamic list using Excel’s new array functions. First, you’ll learn how to combine multiple columns into one column using the TOCOL function. You’ll also learn to leverage the function’s arguments to adjust the list order and ignore blank cells/errors. Lastly, you’ll learn how to combine multiple rows into one using the TOROW function.

Credit Excel Dictionary