|Have you tried to interpret them?|
Why don't you use the Help files for the various nested functions and see if you can get a general idea of what the formulas do?
If you'll post back some words that show that you attempted to figure out the concept behind the formulas, I'll see what I can do about coming up with a formula for your added requirement.
For your latest request all that is required is a simplification of the 2nd formula so that it pulls data from Row 1 all the time.
It is only by studying the solutions that are offered will you increase your Excel knowledge. In fact, I did not know how to solve your problem until I did a Google search about copying and repeating data.
When I found a few suggestions, I studied how they worked and modified what I found to fit your specific situation. By studying what I have offered, you can do the same thing.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.