Transpose and copy data with VBA loop!

Hello,

Here's my situation. I have a pretty big file that i want *certain fields (unique ID's)* of the data within 1 row to be transposed into one column and that same row (excluding the just transposed data) to be copied 23 times (so 24 total because of the original one). So my goal here is to match up that multiple exact rows of data with the Unique ID's. So in essance i want to create duplicate entries EXCEPT for the Unique ID's per every entry. I want to run this for every 24 rows as it represents a different entity 24 rows. Thanks in advance and I will attach an example of what i mean.

Things to keep in mind:
1)all of the column headers are not included in the example provided for simplicity pusposes.

Look at attached example as well for reference.