How to autofill by row grouping

[andreyartemenkov]

Hello, Dear colleagues. I have a dillema. I have an excel file with hierarchical row groupings. On top of each grouing there is an SKU category name followed by serial numbers within the group. I want to replace the (different) serial numbers with the (same) group header (SKU name) to which the serials belong. Is it possible to do such an autofill (e.g. fill down with replacements from the root of each grouping) using the groupings as a array guide? Any help will be appreciated!

 

[jaeiow]

Try using XLOOKUP from the bottom up (using the -1 argument). The lookup array should start with the first row and go down to the current row. Your lookup value would have to be an indent and not two indents. Use TEXTJOIN to concatenate this value with the serial numbers in a new column.