Tom’s Tutorials For Excel: Transform a Range Into a Single Column List

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
=INDEX($A$1:$D$5,ROWS($1:4)/4,MOD(ROWS($1:1)-1,4)+1)
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.

Share Button
Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , ,
2 comments on “Tom’s Tutorials For Excel: Transform a Range Into a Single Column List
  1. Md. Taslimul haque. says:

    Thanks

Leave a Reply

Your email address will not be published. Required fields are marked *

*