Complex TRANSPOSE problem

Hello,

I am trying to transpose a table. The table consists of rows of items and columns showing the ordered quantity. The cells then show the unit price that is paid for each quantity. I want to transpose this table into a 3 column table with the item, quantity and price, omitting the blanks.

Example table before:

Item	1	2	3	4	5
aaa	10	9	8
bbb	15
ccc	20	18	16	15	14
ddd	10	8	6	5	4
eee	30	25	22

Desired result:

Item	Qty	Price
aaa	1	10
aaa	2	9
aaa	3	8
bbb	1	15
ccc	1	20
ccc	2	18
ccc	3	16
ccc	4	15
ccc	5	14
ddd	1	10
ddd	2	8
ddd	3	6
ddd	4	5
ddd	5	4
eee	1	30
eee	2	25
eee	3	22

I know I can use the Excel function to transpose, but it's a lot of lines, so this is a no go. I can do this in VBA. But I prefer to do this in a formula, partly because it's dynamic. I am quite familiar with ARRAY and TRANSPOSE formula's, but I haven't figured this one out yet. Any ideas?

Example report.xlsx