{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["1355"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"1355","index":0,"n_rows":45,"n_cols":11,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Unstack Data that is Separated by Bold Text: Challenge w/Kevin Lehrbass - Formulas, VBA, Power Query"]
["https://www.youtube.com/watch?v=JsErvkFvYf8&t=12s"]
["OZ YouTube Channel:",null,"https://www.youtube.com/user/WalrusCandy"]
["Kevin YouTube Channel:",null,"https://www.youtube.com/user/MySpreadsheetLab"]
["brianxyz at YouTube"]
[]
["Excel Magic Trick 1355 Extract Records Based On Bold Font From a Column, Display Horizontally"]
[]
["Many Fun Topics:"]
[1,"GET.CELL Excel 4 Macro Function to determine when a cell has Bold Font."]
[2,"Create Defined Name that can \"read\" Excel 4 Macro Function."]
[3,"See how to create a Universal Relative Cell Reference in a Defined Name"]
[4,"Helper Column to identify Records for each parent that uses SUM function"]
[5,"Count number of Parents using the MAX function"]
[6,"Extract Parent Names and list vertically using the INDEX, MATCH, IF and ROWS function."]
[7,"Count Number of Children for each Parent with the COUNTIFS, ROWS and IF functions."]
[8,"Extract Children Names and list Horizontally using the INDEX, MATCH, IF, OR and COLUMNS functions"]
[9,"Add Custom Number Formatting to show Numbers as Children Numbers, like 1 displayed as \"Child 1\""]
[10,"Add new records and test formula solution"]
[11,"Learn that the GET.CELL Excel 4 Macro Function requires a complete recalculation using Ctrl + Alt + F9 to get the function to update."]
[]
["People","Bold?",null,"Total Parents"]
["Chastity"]
["Francisco",null,null,"Parent","Number Childeren",1,2,3,4,5,6]
["Rama"]
["Dylan"]
["Mike"]
["Jonah"]
["Jean-Michel"]
["Howard"]
["Belle"]
["John"]
["Veronica"]
["Imani"]
["Lucy"]
["Desiree"]
["Xena",null,null,"To Refresh ISBOLD with GET.CEL Excel 4 Macro Function, you must Refresh All: Ctrl + Alt + F9 (to recalculate All)"]
["John"]
["Mike"]
["Selma"]
["Emerson"]
["Dave Therese"]
["Marsden"]
["Kimberley"]
["Gene"]