Let's see how you can switch rows to columns using the familiar Paste Special technique, but connect the resulting table to the original dataset. How to transpose a table and link it to the original data No one would want to waste their time on switching the same rows and columns over and over again, right? Whenever the source data change, you'd need to repeat the process and rotate the table anew.
0 Comments
Leave a Reply. |