Excel Question

[himanshu sharma]

This excel file contains a list of products which are arranged in rows of 3. Below show a small subset of the data.
Column AColumn BColumn C
Row 1Product 1AProduct 1BProduct 1C
Row 2Product 2AProduct 2BProduct 2C
Row 3Product 3AProduct 3BProduct 3C
......
Can you find a way to re-arrange the products (without using Macro) and list them in one column as shown:
Column A
Row 1Product 1A
Row 2Product 1B
Row 3Product 1C
Row 4Product 2A
Row 5Product 2B

 

[udprocks]

This excel file contains a list of products which are arranged in rows of 3. Below show a small subset of the data.
Column AColumn BColumn C
Row 1Product 1AProduct 1BProduct 1C
Row 2Product 2AProduct 2BProduct 2C
Row 3Product 3AProduct 3BProduct 3C
......
Can you find a way to re-arrange the products (without using Macro) and list them in one column as shown:
Column A
Row 1Product 1A
Row 2Product 1B
Row 3Product 1C
Row 4Product 2A
Row 5Product 2B

Hi Himashu,

See the file hope it will help u.

 

[jayalaxmi]

hello sir,

one question?? Can we use transpose function here...Sorry if m wrong..

Regards,
Jaya

 

[himanshu sharma]

no jaya you are right but transpose is not a proper solution of this table

 

[himanshu sharma]

thanx jitendra but very typical formula any short formula do u have for this table or conditions

 

[udprocks]

hello sir,

one question?? Can we use transpose function here...Sorry if m wrong..

Regards,
Jaya

hallo jailaxmi,

i think no for it for better understanding transpose function please go through below link

http://www.techonthenet.com/excel/formulas/transpose.php

 

[udprocks]

thanx jitendra but very typical formula any short formula do u have for this table or conditions

@himashu

use this one may be it will give u same result.

INDEX($A$2:$D$9,MOD(ROW()-2,COUNTA($A:$A)-1)+1,INT((ROW()-2)/(COUNTA(A:A)-1))+1)

 

[himanshu sharma]

thnx jitendra

 

[udprocks]

thnx jitendra

you'r most welcome mate.

 

[jayalaxmi]

http://www.techonthenet.com/excel/formulas/transpose.php[/quote]
gud link sir...

Thanks

 

[udprocks]

http://www.techonthenet.com/excel/formulas/transpose.php

gud link sir...

Thanks [/quote]
Always welcome dear.