Hi AWat, welcome to the forum. As you posted this in the General forum and not the programming forum, I presume you want a non-VBA solution.

Click GO ADVANCED and use the paperclip icon to post up your workbook. Make sure the 3rd sheet has a mockup of your desired results.