Uploaded December 2016 | Updated September 2026, 2 hours ago

---

Problem: a column of data needs to be unstacked and converted into columns and rows. Twist: the distinction where the list needs to be divided is by bold font.

00:00 Challenge Intro
01:05 Unstacking Logic (3 steps)
01:36 Kevin's Solution
08:02 Oz's Solution

Get Excel file 00154 here: http://1drv.ms/1bYwrTa

Check out Oz's channel:
youtube.com/user/WalrusCandy

Oz's book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analy...

My blog: myspreadsheetlab.com/blog