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!

[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/44...

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

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-Ans...

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-H...

Chris