POWER BI DAX

RESULT = //try this
CALCULATE(
    CONCATENATEX(
        FILTER(
            YourTable,
            YourTable[SEQ] = "BIO"
        ),
        YourTable[RES] & YourTable[RES2],
        ""
    ),
    ALLEXCEPT(
        YourTable,
        YourTable[PCID]
    )
)

Hi BIswajit_Das ,

You can try  below dax to create new table:

CalculatedTable = 
SUMMARIZE (
    'Table',
    'Table'[PCID],
    "RESULT",
    CALCULATE (
        CONCATENATEX (
            FILTER (
                'Table',
                'Table'[SEQ] = "BIO"
            ),
            'Table'[RES] & 'Table'[RES2],
            ""
        )
    )
)

if you want to use it in table column, try below dax:

RESULT1 = 
CALCULATETABLE (
    SELECTCOLUMNS (
        VALUES('Table'[PCID]),
        "RESULT",
        CONCATENATEX (
            FILTER (
                'Table',
                'Table'[SEQ] = "BIO" && 'Table'[PCID] = VALUES('Table'[PCID])
            ),
            'Table'[RES] & 'Table'[RES2],
            ""
        )
    )
)

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

BIswajit_Das Do you wish to have this column in the same table or separately. if it should be in the same table

simple if function can help you to get the required column