'Extracting couple values from column based on unique values from another column

need your consultation on how to make automatic table conversion (left side is what I will fill manually) and on the right side is what I want to receive based on unique values collected from Product column enter image description here

Below is the link for the original. Thank you for your time. https://docs.google.com/spreadsheets/d/1NHNmSKTmIqBCvwcsfhnU3LlnhHYyCC4Ou9BX_t-_3nE/edit?usp=sharing



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source