Converting a Grid into Clean Segmented Lists
409 views · Published 10 March 2016 · 7:05 · Indexed 23 September 2026
Channel: Excel On Fire (Oz du Soleil) · 2016 · Education
Over at Reddit /r/excel LSatyreD asked about converting a massive grid of ingredients into their corresponding recipes. In this video, I show how to do this without writing code! In Excel 2016, Get & Transform and a pivot table will get the desired result. (In Excel 2010 and 2013, Power Query is the old name for Get & Transform) Also, see that a new recipe can be integrated with a simple 'refresh.' My blog: http://datascopic.net/blog2-2 Guerrilla Data Analysis 2nd Edition http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336 The original Reddit question: https://www.reddit.com/r/excel/comments/49ho4o/how_to_consolidate_a_sheet/
More from this channel
-
5:03
Basic Excel Table Demo
-
10:28
Generating Random Data to Set Up a Pivot Table Tutorial
-
8:23
Excel Data Validation: Why It's Important
-
3:41
Excel demo: retrieving current and historical stock data from the web.
-
5:45
Sriracha Taste Test 2: Sky Valley, Saigon Sisters & Lee Kum Kee
-
8:38
Excel Helps Determine the Dog's Fate
-
18:20
Pressman by Primus (Using Excel to study song structure)
-
8:12
Why Data & Excel: feeling the true impact