Need formula 2 Column to One Column

[lgchandana]

forum.png

I need to get ( Name, Gender, Poition, Manage to one column Row by row. one after another)

Can anyone give formula for this. I'm not expert excel formulas.

[¯\_(ツ)_/¯]

If that's all your data, then in C14 thru C17 use:

=A14
=B14
=A15
=B15

If this isn't an actual representation of your data, provide more details.

[azumi]

Consider your table on ranges A1 to B2, put this on D1 and copied down :

=OFFSET($A$1,MOD(ROW()-ROW($A$1),ROWS($A$1:$A$2)),TRUNC((ROW()-ROW($A$1))/ROWS($A$1:$A$2)),1,1)

[¯\_(ツ)_/¯]

Azumi, your function returns

NAME
POSITION
GENDER
MANAGE

OP is looking for

NAME
GENDER
POSITION
MANAGE

Assuming data starts in A1 and proceeds down columns A and B, this formula should work in C1 and filled down:

Please Login or Register  to view this content.

[azumi]

Deleted Post