In fact at the time of recording the video I didn't know how to solve the problem of #N/A appearing in cells that are outside the range of the formula. Whereas this solution of solving this Excel problem is a little more flexible that the copy & paste solution of method 1 but because it's an array function it can limit where you would use this.
The Transpose function is an array function that allows you to transpose data from horizontal to vertical and vertical to horizontal. Method Number 2 - Using the TRANSPOSE function Should you want to change the source data you will have to go through this process again so if we were rating this I would give this a 4/10. 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 kommentar(er)
