Uploaded January 2016 | Updated September 2026, 2 hours ago

---

Get Excel file 00141 here: http://1drv.ms/1bYwrTa
I first saw this challenge via a Bill Jelen (Mr Excel) tweet. The tweet directed me to Bill's free Excel help forum. Several excellent VBA solutions. In this video I explain a formula based solution.

(00:00) Mr Excel forum
(01:03) Requirement Description
(01:40) Array formula tell us how many rows we need
(01:50) Solutions steps

Kevin Lehrbass
twitter.com/kevinlehrbass
myspreadsheetlab.com/video-00142-horizontal-list-to-vertical-list-layered-transpose