Row to Column

[Jeffrey]

Hello,

I have difficult to convert data as follow:

Original:
Column A Column B Column C Column D Column E Column F
China 0.1 86 8610 8620
8621

After (Conversion):
Column A Column B Column C
China 0.1 86
China 0.1 8610
China 0.1 8620
China 0.1 8621

Can anyone help me solve the Above Issue, from ORIGINAL to AFTER. I have a
lot range of 3000 need to do. Therefore, please kindly HELP me.

Thank you very much.

 

[MRT]

Sheet2-A1: =INDEX(Sheet1!A:F,INT((ROW()-1)/4)+1,1)
Sheet2-B1: =INDEX(Sheet1!A:F,INT((ROW()-1)/4)+1,2)
Sheet2-C1: =INDEX(Sheet1!A:F,INT((ROW()-1)/4)+1,MOD(ROW()-1,4)+3)

HTH