Using the TRANSPOSE function

[sj5603]

I have a table that I would like to transpose from
horizontal to verticle. It is structured like a database
with the fields in columns and the records in rows. I
would like to transpose the field column headings (field
names) to a single column showing all of the field
headings.

Example: Transpose this-

Heading1 Heading2 Heading3
123 456 789

to this-

Heading1 123
Heading2 456
Heading3 789

From the the Excell "TRANSPOSE" function description, it
seems like this function will do what I want. But I do
not understand the syntax of the function, or the
terminology used to describe how it works.

Bottom line is that I want this tool to do something for
me and I need help making it work. So, PLEASE!!!!!! Help

 

[Frank Kabel]

Hi
if this is a one-time operation try the following:
- select your source range and copy it
- goto your target and choose 'Edit - Paste Special - transpose'

 

[Max]

Perhaps try this set-up to get the hang of using TRANSPOSE()?

Assuming the source range below
is in A1:C2 (ie a 2R x 3C grid)

Heading1 Heading2 Heading3
123 456 789

Select the destination range for the tranpose
say A4:B6 (dest. range must be a 3R x 2C grid)

Put in the *formula bar*: =TRANSPOSE(A1:C2)

Array-enter the formula, i.e.:
Hold down CTRL + SHIFT, press ENTER
(instead of just pressing ENTER)

Done correctly, Execl will wrap curly braces around the formula, viz.:
{=TRANSPOSE(A1:C2)}

Don't type-in the curly braces yourself!

The same formula {=TRANSPOSE(A1:C2)}will appear
in each of the cells in A4:B6

Changes in the source A1:C2 will be auto-reflected
in the transposed destination range A4:B6

 

[Guest]

Thanks Frank. Works like a charm.
Sorry about the double post. This is the first time I
have used this, and I was not sure about where the first
post went.

Regards, Stacy

 

[Guest]

Thanks Max. Works like a charm.

Regards, Stacy

-----Original Message-----
Perhaps try this set-up to get the hang of using TRANSPOSE ()?

Assuming the source range below
is in A1:C2 (ie a 2R x 3C grid)


Select the destination range for the tranpose
say A4:B6 (dest. range must be a 3R x 2C grid)

Put in the *formula bar*: =TRANSPOSE(A1:C2)

Array-enter the formula, i.e.:
Hold down CTRL + SHIFT, press ENTER
(instead of just pressing ENTER)

Done correctly, Execl will wrap curly braces around the formula, viz.:
{=TRANSPOSE(A1:C2)}

Don't type-in the curly braces yourself!

The same formula {=TRANSPOSE(A1:C2)}will appear
in each of the cells in A4:B6

Changes in the source A1:C2 will be auto-reflected
in the transposed destination range A4:B6

 

[Max]

You're welcome, Stacy !
Thanks for the feedback

 

[za111]

You can copy this area and select paste special ->
transpose. That's it!