Forum Discussion
Transposing tabs/sheets within a Workbook in Excel
Hi All, I am trying to transpose tabs/sheet on an excel workbook since i have multiple tabs and would be easier if they were arranged vertically than horizontally. It is sort of your EDGE b...
A solution could be Power Query. In the attached file you can enter data in the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse. Then select refresh to update the green result table.
The layout of the tables in the screenshot is for illustration. Both tables can be draged to other columns or the tables can be entered in different sheets.
OliverScheurich - Thanks much for the response. I am attaching a sample excel where it shows sheet1, sheet 2, sheet3. I am looking to have the sheets transposed horizontally than vertically. I mean I want to see it show up on the left than at the bottom of the workbook.