SELECT DISTINCT 
    Transaction.TranID,
    BUILTIN.DF(Transaction.Type) AS Type,
    BUILTIN.DF(Transaction.Status) AS Status,
    BUILTIN.DF(TransactionLine.Item) AS Item,
    SUM(TransactionLine.Quantity) AS Quantity, 
    MAX(CASE WHEN CUSTOMRECORD_WMSSE_SKU_ALIAS.custrecord_wmsse_alias_desc LIKE '%BX%' THEN REPLACE(REGEXP_SUBSTR(BUILTIN.DF(CUSTOMRECORD_WMSSE_SKU_ALIAS.custrecord_wms_alias_unit), '-\s*([0-9]+)', 1, 1, 'i'), '-','') END) AS piecesperinner,
    MAX(CASE WHEN CUSTOMRECORD_WMSSE_SKU_ALIAS.custrecord_wmsse_alias_desc LIKE '%MC%' THEN REPLACE(REGEXP_SUBSTR(BUILTIN.DF(CUSTOMRECORD_WMSSE_SKU_ALIAS.custrecord_wms_alias_unit), '-\s*([0-9]+)', 1, 1, 'i'), '-','') END) AS MasterQuantity,
    CUSTOMRECORD_WMSSE_SKU_ALIAS.name AS masterbarcode
FROM 
    Transaction
    INNER JOIN TransactionLine ON (TransactionLine.Transaction = Transaction.ID)
    INNER JOIN Item ON (Item.ID = TransactionLine.Item)
    INNER JOIN CUSTOMRECORD_WMSSE_SKU_ALIAS ON (item.id = CUSTOMRECORD_WMSSE_SKU_ALIAS.custrecord_wmsse_alias_item)
WHERE 
    Transaction.Status = 'TrnfrOrd:F' AND TransactionLine.Quantity > 0
GROUP BY 
    Transaction.TranID, 
    BUILTIN.DF(Transaction.Type), 
    BUILTIN.DF(Transaction.Status), 
    BUILTIN.DF(TransactionLine.Item), 
    CUSTOMRECORD_WMSSE_SKU_ALIAS.name
ORDER BY 
    BUILTIN.DF(TransactionLine.Item) ASC;

How do i get the results onto 1 line? like this

Which masterbarcode are you going to show? You have two different values

i want the master case barcode so when alias unit is like MC

Sorry I don’t know what you mean. Your two rows in the first screenshot have different values for “masterbarcode”. How do you know which you want to show?