Transfer data in two sheets to final sheet

Hello everyone
I have attachment with a code that do my task ...
so it is solved

I need to devise code using arrays as the original data is over 20000 rows ...
The Final sheet will show you the expected results

Another point if possible to format the results

In Sheet Question you have Questions in Coulmn "E"

So you can add as many questions you want...
Note the Numbering should be taken care off..

like
Question
1
2
3
4
5
6
7
8
.... & so on..


In Answers Sheet Keep adding the Question Number in A column & Answers option in C column & run the Existing macro.. it will run for as much data you enter accurate..

Hi,
I left most untouched, and added only 3 tables

Please Login or Register  to view this content.

shall be much quicker with large datasets than cell-by-cell approach

PS. As your columns B:D in Questions are empty, it could be even shorter (no need to source2 and to transfer values from source2 to outtable row by row):

Please Login or Register  to view this content.

Thank you very much Mr. Kaper for this magic and perfect solution
Thanks a lot for help

You are welcome, and thanks for reputation :-)