Combine rows based on column value

I am not sure exactly how to phrase this, which probably explains why I can't find a pre-existing answer. Anyway I have a table that has multiple items which are repeated throughout by month and yea...

Need Help

Anonymous

7 years ago

Hi bvilten,

You can try to use following formulas to extract item group and combine sub items.

Calculate column formulas:

Item Group = PATHITEM(SUBSTITUTE([Item],"/","|"),1)

Combined = 
CALCULATE (
    CONCATENATEX (
        VALUES ( Sheet1[Item] ),
        REPLACE (
            [Item],
            1,
            LEN ( PATHITEM ( SUBSTITUTE ( [Item], "/", "|" ), 1 ) ) + 1,
            ""
        ),
        "/"
    ),
    FILTER ( ALL ( Sheet1 ), [Item Group] = EARLIER ( Sheet1[Item Group] ) )
)

Regards,

Xiaoxin Sheng

Forum Discussion

Combine rows based on column value

Related content

Combine Column

Combining Column Data

Combine columns into 1

Tables combine

Sequential Order column based on multiple criteria