Episode 262 - Customer SubHeadings

In today's dataset, someone tried to make a report look nice by putting the customer number and customer name only once for every group of records. This looks fine, but it is impossible to use in any sort of data analysis. Episode 262 will show you the formulas you can use to copy the customer information down to new columns.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!