https://dailydevsblog.com/troubleshoot/resolved-detect-immediate-parent-rows-of-each-row-and-add-their-values-to-a-new-column-309543/