Could you sold for me as attachment file below?
Solved! Go to Solution.
You could use the "stack" function for your first problem and for the second you could write a custom function to create a matrix to your specifications.
BTW, its always better to additionally attach the worksheet itself additionally and not just post pictures.