Tom’s Tutorials For Excel: Transform a Range Into a Single Column List
Here’s how you can take a range of data comprised by multiple columns and rows, and list its items in a single column.
In the picture, all the items in range A1:D5 are listed in column F with the formula
that is entered into cell F1 and copied down as far as you’d need to in order to capture all the cells in the data range.
Note in the formula that the number 4 represents the fourth column in the range, which in this example is column D.