Excel: Transpose via formulas

[krets]

Is there a way to easily auto-fill formulas that transpose data? What I have is a set of data that has the date on the X-axis and different error codes along the Y-axis.

I'd like to recreate the table using formulas on a different sheet but the data needs to be transposed. When I've tried to use simple look ups and auto-fill it's not doing what I want.

 

[GlennUK]

If it's a fixed region of cells you could use the TRANSPOSE function in an array formula ( select a region equal ot the transposed size of the source range, and enter a formula of

=TRANSPOSE(source_range)

and enter using Ctrl-Shift-Enter instead of Enter.



Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.