Excel formula to Transpose data

[rizmomin]

Hi:

I have excel sheet1 (Employees) with Name of employees in cell P1,Q1,R1, and so on.

I need the formula to transpose Name of employees in sheet2 in D6,D7,D8 and so on.

Thank you on advance for the help.

RM.

[Søren Larsen]

=TRANSPOSE() confirmed with Ctrl+Shift+Enter.

Before writing your formula, you need to mark the entire area to where you want transpose.

[jeffreybrown]

Look at the function =TRANSPOSE(array)

[rizmomin]

Hi:

Please refer to the attached sheet and help with formula.

Thanks
RM

[jeffreybrown]

On the Transpose tab, highlight C6:C42

Type =TRANSPOSE(Employees!$P$1:$AZ$1)

to confirm function, press Control + Shift + Enter

If done correctly, the formula will be encased with {}.

Do not enter these manually

[rizmomin]

Hi :

I will have employee list updated every pay period.
So would i need to do this every time.
If so then this will be a problem.
I wanted an easy way to transpose.

Thanks
RM

[jeffreybrown]

Easy is a relative term as to what you want to accomplish. How ofter is a pay period? Once a month, Every other week, Once a week?

Will the number of employees always be the same? Right now you have 37 Employees from Adriana to Victoria. If they are the same you can just paste over the existing employees and the Transpose function will pick up the new employess.

Another alternative could be VBA. Do you want this?

[nilem]

Hi Rizmomin. Maybe so

Please Login or Register  to view this content.

[rizmomin]

Hi :

Yes i think i would be ok with VBA as per Nilem's code.
Works great.
Thanks a lot to all of you.

RM