![]() Obviously the downside to this is that it is not flexible. ![]() If fact some of you may already be more that familiar with selecting text and using the paste special - transpose way of doing this. ![]() The copy and paste method is by far the most straightforward method of transposing data. But I thought if I went through 3 ways then the choice would be up to you. Now it's true that there are other ways of accomplishing this task. However, the data they received was in the wrong format. The reason for this Excel tutorial was that I had a client that had the responsibility of preparing data for a pivot table. You know, converting horizontal excel data to vertical data or rows into columns. This tutorial will show you 3 ways to transpose data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |