Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! X
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.