Transpose data from column to row layout

When using data in Excel it is generally created or delivered by 3rd party applications in a columnar layout.

Transpose1

 

 

 

 

 

 

If the data is needed in a row layout, this can be easily achieved with just a few clicks of the mouse!

Transpose2

 

Your data will magically be transposed!

 

Transpose3

 

This can be used for multiple columns of data as well, so using the the above example and copying columns B & C would be transposed as follows

Transpose4

 

 

Get more great content from Rousseau Associates

Start your project with us today

Call +44 (0)1757 269461

Discuss your requirements today