Introduction The TOCOL function converts a multi-column Excel range into a single vertical column. For example, =TOCOL(A1:C4) stacks the values in row order, while optional arguments let you ignore blanks or scan by column. If your Excel version does not support TOCOL, the VBA alternative below provides another approach. Have you ever struggled with rearranging your data from a multi-column format into a single column? Manually copying and pasting is… Read More »Flatten an Excel Range into One Column with TOCOL or VBA