Transpose not working the way I'd like

[danjab]

Hi Everyone,

Happy Holidays!

Here's what I can't figure out. I have a file (attached) that I want to transpose, so that the first column is NAME (and all the names go under it), the second column is TYPE, third is ADDRESS, and fourth is PHONE.

I found the TRANSPOSE function, and followed the steps, including hitting CTRL+SHIFT+ENTER at the end.
The first row did what I wanted, but you'll see the dreaded #N/a for all the other rows. What did I do wrong? Or is there a different way to do what I want to do?

Thanks in advance for your help!

Dan Jablons

[Bo_Ry]

Please try at Agents (2) C2

=INDEX($B:$B,(ROWS(C$2:C2)-1)*COLUMNS($C$1:$F$1)+COLUMNS($C2:C2))

[danjab]

Thank you so much!

[Norie]

Dan

Try this in C2 and copy across and down.

=INDEX($B:$B,COLUMN()-2+(ROW()-2)*4)

[danjab]

Thank you very much!