Hello,

I need your help for the report/data I'm currently working on. I have a tab that contains the summary information, and I need to transfer it to another tab for the detailed data.

Here is the Main tab:

Origin City Destination City Volume # of shipments
Hong Kong Kaohsiung 1.2 4
Bangkok Manila 3 2

Here is how it should appear in the detailed tab:

Origin City Destination City Volume # of shipments
Hong Kong Kaohsiung 1.2 4
Hong Kong Kaohsiung 1.2 4
Hong Kong Kaohsiung 1.2 4
Hong Kong Kaohsiung 1.2 4
Bangkok Manila 3 2
Bangkok Manila 3 2

Would you know the formula or macro for this because I got like a thousand information to replicate depending on the # of shipments.