ExcelBanter - Transposition

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

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

- - Transposition (https://www.excelbanter.com/excel-worksheet-functions/8815-transposition.html)

Kuna&Zagiel

Transposition

Can one easily transpose a column to line or opposite?

Arvi Laanemets

Hi

PasteSpecial with Transpose checked (NB! Source and target ranges mustn't
intersect!)

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets

"Kuna&Zagiel" wrote in message
...
Can one easily transpose a column to line or opposite?

JulieD

Hi

also note that edit / paste special - transpose only works with "copied"
data not "cut" data.

Cheers
JulieD

"Arvi Laanemets" wrote in message
...
Hi

PasteSpecial with Transpose checked (NB! Source and target ranges mustn't
intersect!)

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets

"Kuna&Zagiel" wrote in message
...
Can one easily transpose a column to line or opposite?

All times are GMT +1. The time now is 08:34 PM.