=ARRAYFORMULA(
  IFNA(
    VLOOKUP(
      Main!A2:A,
      {
        UNIQUE(FILTER(A2:A, A2:A <> "")),
        SPLIT(
          REGEXREPLACE(
            TRIM(
              TRANSPOSE(QUERY(
                IF(
                  TRANSPOSE(UNIQUE(FILTER(A2:A, A2:A <> ""))) <> INDEX(SORT(FILTER(A2:B, A2:A <> ""), 1, 1, 2, 1),, 1),,
                    INDEX(SORT(FILTER(A2:B, A2:A <> ""), 1, 1, 2, 1),, 2) & "♥"
                ),,
                10^7
              ))
            ),
            "♥$",
            ""
          ),
          "♥ ",
          0
        )
      },
      SEQUENCE(
        1,
        MAX(QUERY(
          {A2:A},
          "SELECT COUNT(Col1)
           WHERE Col1 IS NOT NULL
           GROUP BY Col1
           LABEL COUNT(Col1) ''",
          0
        )),
        2
      ),
      0
    )
  )
)