How to record data that created based on a drop-down list in Excel using VBA

I have an excel spreadsheet that give me a result column (say 100 rows) based on the selection from a common drop down list (say 30 nos). I want to record the result column for all the values in the drop down list in a separate table (like 30columns x 100 rows).

Can anyone please help me with this?

Thank you in advance