ExcelBanter - How do I switch datas in the rows and column?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I switch datas in the rows and column? (https://www.excelbanter.com/excel-worksheet-functions/264757-how-do-i-switch-datas-rows-column.html)

RamS

How do I switch datas in the rows and column?

Fred Smith[_4_]

How do I switch datas in the rows and column?

It's called "transpose". Copy your data, Paste Special..., check Transpose.

Regards,
Fred

"RamS" wrote in message
...

All times are GMT +1. The time now is 10:44 AM.