ExcelBanter - how to interchange rows to columns & columns to rows in a table

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how to interchange rows to columns & columns to rows in a table (https://www.excelbanter.com/excel-discussion-misc-queries/98311-how-interchange-rows-columns-columns-rows-table.html)

kotakkamlesh

how to interchange rows to columns & columns to rows in a table

can any one help me as to how to interchange rows & columns in a table

David Biddulph

how to interchange rows to columns & columns to rows in a table

"kotakkamlesh" wrote in message
...
can any one help me as to how to interchange rows & columns in a table

Either the TRANSPOSE function, or

Cut/ Paste Special/ Transpose
--
David Biddulph

All times are GMT +1. The time now is 07:04 AM.