ExcelBanter - Row to Column

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Row to Column (https://www.excelbanter.com/excel-worksheet-functions/247158-row-column.html)

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.

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
--
MRT

"Jeffrey" <Jeffrey @discussions.microsoft.com wrote in message ...
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.