Uploaded July 2015 | Updated September 2026, 2 hours ago

---

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

My dog Cali has a data nightmare! Yes, this is a dramatization but this really does happen!

1. (00:00) Cali's data problem description
2. (01:05) Step 1 Normalize via ALT D P
3. (01:27) Step 2 Extract data from pivot cache
4. (01:48) Step 3 Delimit data using 'Ctrl' & 'J' not using "-"
5. (02:43) Step 4 Concatenate City & Region, Alt D P
6. (03:16) Step 5 Extract data from pivot cache
7. (03:23) Step 6 Delete row if value is blank. Text to Columns

Cheers,
Kevin Lehrbass
twitter.com/kevinlehrbass