Create table with rearranged data

I have data in a table as the following:

Deal ID Product A Product B Product C
10115 1 2
10967 1
11267 2 1
11365 1

I want to create a table like this: It repeats the deal ID, then product and qty.

Deal ID Product Qty
10115 Product A 1
10115 Product C 2
10967 Product B 1
11267 Product A 2
11267 Product B 1
11365 Product B 1

I will really appreciate if anyone can help? Not sure how to add an attachment.

you should be able to use Power Query (Data tab, "Get and Transform Data") and in Power Query, "Unpivot" the product columns.

Excellent mate, that worked. got a slight error, We couldn't convert to Number but converted the data to text and it fixed it. Thank you so much.