Dueling Excel - "Collapse with a Formula": Podcast #1429

Today’s Dueling Excel looks at what the I.T. Department is sending down. It’s an ugly report, each day, and we want to collapse multiple lines – for each person – into a single line. But it is more complicated than that; we have to Concatenate First Name and Last Name, plus a Lookup to figure out which Column should be reported. Follow along with Episode #1429 as Bill ‘MrExcel’ Jelen employs a PowerPivot Solution and Mike ‘ExcelisFun’ Girvin employs a Formula to solve this week’s challenge.

Please Note: The Video Podcast for this Episode [#1429] would not upload to Libsyn on it's original Date. As a temporary measure, if you cannot view the video podcast, please visit The "Learn Excel from MrExcel" Blog - Here, on WordPress for todays Dueling Podcast #83.

…This blog and video podcast is brought to you by the book, Learn Excel 2007 through Excel 2010 from MrExcel by Bill Jelen. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com - Your One Stop for Excel Tips and Solutions