Prev: validate date entered
Next: VLOOKUP with WORKDAY?
From: Jeffrey Jeffrey on 31 Oct 2009 22:20
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.

From: MRT on 1 Nov 2009 00:43
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 news:73BBB0B8-3979-4A4B-A2B2-410FDA56148E(a)microsoft.com...
> 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.
 | 
Pages: 1
Prev: validate date entered
Next: VLOOKUP with WORKDAY?