Query to display aggregate information of several items on single line

I'm having trouble trying to display aggregate data from a bigquery table into a single line.

I have a table containing information like brand_id, brand_name, product_id, product_name, product_price, product_id, product_description, product_sales, positive_reviews and negative_reviews:

What I want to do is display the information of the top 10 best selling products of each brand, having one row for each brand. Like so:

I have tried two approeaches so far:

1. Create a CTE with product rankings by brand and left join the CTE with itself ten times, filtering by rank on each join.
2. Create a CTE with product rankings by brand and pivot results.

OPTION 1

WITH RANKED_PRODUCTS
AS
(
    SELECT
        BRAND_ID,
        BRAND_NAME,
        PRODUCT_ID,
        PRODUCT_NAME,
        PRODUCT_DESCRIPTION,
        PRODUCT_PRICE,
        PRODUCT_SALES,
        POSITIVE_REVIEWS,
        NEGATIVE_REVIEWS,
        RANK() OVER(PARTITION BY BRAND_ID ORDER BY PRODUCT_SALES DESC) AS RANK
    FROM PRODUCTS
)
SELECT
    RP.BRAND_ID,
    RP.BRAND_NAME,
    RP.PRODUCT_ID,
    RP.PRODUCT_NAME,
    RP.PRODUCT_DESCRIPTION,
    RP.PRODUCT_PRICE,
    RP.PRODUCT_SALES,
    RP.POSITIVE_REVIEWS,
    RP.NEGATIVE_REVIEWS,
    RP2.BRAND_ID,
    RP2.BRAND_NAME,
    RP2.PRODUCT_ID,
    RP2.PRODUCT_NAME,
    RP2.PRODUCT_DESCRIPTION,
    RP2.PRODUCT_PRICE,
    RP2.PRODUCT_SALES,
    RP2.POSITIVE_REVIEWS,
    RP2.NEGATIVE_REVIEWS,
    (...)
    RP10.BRAND_ID,
    RP10.BRAND_NAME,
    RP10.PRODUCT_ID,
    RP10.PRODUCT_NAME,
    RP10.PRODUCT_DESCRIPTION,
    RP10.PRODUCT_PRICE,
    RP10.PRODUCT_SALES,
    RP10.POSITIVE_REVIEWS,
    RP10.NEGATIVE_REVIEWS
FROM RANKED_PRODUCTS RP
LEFT JOIN (
SELECT BRAND_ID, PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, PRODUCT_PRICE, PRODUCT_SALES, POSITIVE_REVIEWS, NEGATIVE_REVIEWS
FROM RANKED_PRODUCTS WHERE RANK = 2
) RP2 USING (BRAND_ID)
(...)
LEFT JOIN (
SELECT BRAND_ID, PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, PRODUCT_PRICE, PRODUCT_SALES, POSITIVE_REVIEWS, NEGATIVE_REVIEWS
FROM RANKED_PRODUCTS WHERE RANK = 10
) RP10 USING (BRAND_ID)
WHERE RANK = 1

This option works, but the query takes a long time and honestly it doesn't fell right. There must be a better way.

OPTION 2

SELECT
    *
FROM (
SELECT
    BRAND_ID,
    BRAND_NAME,
    PRODUCT_ID,
    PRODUCT_NAME,
    PRODUCT_DESCRIPTION,
    PRODUCT_PRICE,
    PRODUCT_SALES,
    POSITIVE_REVIEWS,
    NEGATIVE_REVIEWS,
    RANK() OVER(PARTITION BY BRAND_ID ORDER BY PRODUCT_SALES DESC) AS RANK
FROM PRODUCTS
) PIVOT (
    MAX(PRODUCT_DESCRIPTION) AS PRODUCT_DESCRIPTION,
    MAX(PRODUCT_PRICE) AS PRODUCT_PRICE,
    MAX(PRODUCT_SALES) AS PRODUCT_SALES,
    MAX(POSITIVE_REVIEWS) AS POSITIVE_REVIEWS, 
    MAX(NEGATIVE_REVIEWS) AS NEGATIVE_REVIEWS
    FOR RANK IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10))

This options feels a lot better, and seems to be on the right track. Unfortunately the output is not what I desire:

I do know that I could add another query on top of this one in order to have all results on a single line, but again this feels kind of wrong.

Any ideas on what could be done?