Transpose vertical values to horizontal

[GeraldDLT]

Hi All,

i need your help again, first thank you for reading this. I have a lot of data in vertical position my boss ask me to transpose it in horizontal. Please help me. Thank you.



Cheers,
Gerald

 

[xlstime]

HI GeraldDLT,

See if this help

Hi All,

i need your help again, first thank you for reading this. I have a lot of data in vertical position my boss ask me to transpose it in horizontal. Please help me. Thank you.



Cheers,
Gerald

 

[GeraldDLT]

HI GeraldDLT,

See if this help

xlstime, thats awesome! how do you do that!?

 

[GeraldDLT]

HI GeraldDLT,

See if this help

One more question xlstime, how do i do it if it's in the other sheet?

 

[bosco_yip]

Hi,

Another option in using non-array formula.

1] In Sheet1 I8, formula copy across and down :

=LOOKUP(2,1/($A$2:$A$10=$G8)/($D$2:$D$10=I$7),$C$2:$C$10)

Or,

2] If the result sheet is in the other sheet, say Sheet2.

In Sheet2 C3, formula copy across and down :

=LOOKUP(2,1/(Sheet1!$A$2:$A$10=$A3)/(Sheet1!$D$2:$D$10=C$2),Sheet1!$C$2:$C$10)

Regards

 

[GeraldDLT]

Hi,

Another option in using non-array formula.

1] In Sheet1 I8, formula copy across and down :

=LOOKUP(2,1/($A$2:$A$10=$G8)/($D$2:$D$10=I$7),$C$2:$C$10)

Or,

2] If the result sheet is in the other sheet, say Sheet2.

In Sheet2 C3, formula copy across and down :

=LOOKUP(2,1/(Sheet1!$A$2:$A$10=$A3)/(Sheet1!$D$2:$D$10=C$2),Sheet1!$C$2:$C$10)

Regards

It's an honor to meet you bosco_yip.

 

[bosco_yip]

It's an honor to meet you bosco_yip.

Hi GeraldDLT,

You're welcome.

Regards
Bosco

 

[xlstime]

Hope you got your answers with Bosco's formula, this is simple and easy to understand.

One more question xlstime, how do i do it if it's in the other sheet?

 

[GeraldDLT]

xlstime & bosco_yip I thank both of you for all of your ideas, i've learn a lot just from those samples. But i'll be needing your help once more. The opposite of attendance, schedule.

 

[xlstime]

Me with still Index match

E2=INDEX($M$7:$Q$10,MATCH($A2,$M$7:$M$10,0),MATCH($D2,$M$7:$Q$7,0))
and drag

xlstime & bosco_yip I thank both of you for all of your ideas, i've learn a lot just from those samples. But i'll be needing your help once more. The opposite of attendance, schedule.

 

[GeraldDLT]

Me with still Index match

E2=INDEX($M$7:$Q$10,MATCH($A2,$M$7:$M$10,0),MATCH($D2,$M$7:$Q$7,0))
and drag

Thanks a lot xlstime, i think i will not encounter #N/A value.

 

[GeraldDLT]

Me with still Index match

E2=INDEX($M$7:$Q$10,MATCH($A2,$M$7:$M$10,0),MATCH($D2,$M$7:$Q$7,0))
and drag

It works! thanks again xlstime.