Row to Column
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.
|