Menu hierarchy file need help to flatten file with cross tab or multi-row formula

kristinfreitas

I have an example file attached.  Columns A-E are the raw data.  I want to add the highlighted columns F and G.  Menu name (column F) should equal the menu field (column C) if the Type (column D) is Menu.  If the Type (column D) is Function, I want the Function Name (column G) to equal the Menu field (column C) and I want to the Menu Name (column F) to equal the Menu for the row above (may be one row above or several rows above).  Hoping to get some help on the best way to do this!

Menu Hierarchy example.xlsx

ChrisTX

These posts may help:

Weekly Challenge #12: https://community.alteryx.com/t5/Weekly-Challenge/Challenge-12-Creating-an-HR-Hierarchy/td-p/36740

Crawl through a file https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Crawling-Down-an-Org-Structure/td-p/440632

Generate each tree branch for a hierarchy https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Multilevel-Product-Hierarchy/m-p/422343#M78326

Employee Manager org hierarchy https://community.alteryx.com/t5/Alteryx-Designer/Employee-Manager-org-hierarchy/m-p/599546#M133788

Traverse a Hierarchy https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Looking-up-and-Down-a-Hierarchy-to-Answer-Questions/m-p/747993#M179230

Generate a flat layout from a hierarchy (employee / manager): Use an Iterative macro: see workflow HierarchyLookup.yxzp: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Producing-a-denormalised-output-from-Hierarchial-Data/td-p/5164/page/2

Chris