Click OK after you have chosen the range where you want to switch rows and columns.Open the target worksheet, press Alt + F8, choose the TransposeColumnsRows macro, and click Run. How to use macro to convert row to columnĪfter adding the macro to your workbook, follow the steps below to rotate your table: This method also copies the way the original data was formatted, which is another point in its favour.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |