Propagation of values in a spreadsheet

[Askalian]

Hello,

Can somebody help me on this question ?

I have a series of figures :

X1 and a associated number : 50.000
X2 and a associated number : 30.000
X3 and a associated number : 20.000
X4 and a associated number : 10.000
X5 and a associated number : 5.000
X6 and a associated number : 2.500
X7 and a associated number : 1.000
X8 and a associated number : 500

The sum of X1 + X2 + X3 + X4 +X5 +X6 +X7 +X8 is always 40,
such as 1,2,3,4,5,5,10,10 or 5,5,5,5,5,5,5,5

I would like to propagate in 40 horizontal cells :

- As many 50.000 as I have of X1, for instance 50.000, 50.000, 50.000 if X1 = 3.
- Same for 25.000
- Same for other numbers.

See attached example spreadsheet.

Thanks for your kind help.
Askalian