Automatically moving rows into columns

[morcorp]

Can you please help me in setting up a sheet or formula so I can automatically move three rows across multiple columns into three columns with multiple rows? Thanks!

[Kerry Newman]

Copy the 3 columns, go to where you want the "rows" to start, go Paste Special, Transpose. If there are formulas in your original data, Paste Special, Values and Transpose......

[day92]

This macro will do the trick.

Please Login or Register  to view this content.