Flip the spreadsheet

[Clash]

Hi All,

Just a quick one, is there an easy way of flipping a spreadsheet. So that all the the columns become the rows, and vice versa and all the data is moved accordingly.

Cheers

[Dav]

Perhaps copy then paste special and select transpose

Does that help

Regards

Dav

[Clash]

sorry I haven't replied, I'll give it a go.

Thanks.

You are great, works a treat. Thanks m8