But if you are using Transpose function and perform any change in the source data it will reflect in the transposed data also. The drawback with Paste special method is that if we perform any change in the source data it does not reflect in the transposed data. There are two methods to perform the transpose first is Paste Special method, second Transpose function. It is applicable to arrays. Transpose is an array function i.e. Then, use it again with T to bring in formatting.Now you'll have a replica of the original data without formulas.You can also use Paste Special with to copy formatting only.In this example, new data has been pasted below with no formatting.If you fail to find it there, you can also search it in Paste Special options that appear just below the Paste Options. Let us start with Paste special:Step 1: Select the complete data that you want to transpose and Copy it.Step 2: Right click your mouse and reach Paste Options, and search for the Transpose (T) button. For this, I have to apply transpose to the data.As discussed above there are two methods to transpose in Excel. Where months data lies in rows and years data lies in columns.But I want the years to be in rows and months to be in columns. Now, in the image below you can see, I have data that shows the collection from the year 2011-2015 in all months.
Transpose function automatically fills the cell code.Step 3: After that close the TRANSPOSE function bracket and press Cntrl+Shift+Enter. You can observe that the =TRANSPOSE (Cell 1 : Cell N i.e. Now select all the cells that would store the transposed data.Step 2: Then type =TRANSPOSE( and select the data array that you want to transpose. This is only to get an idea of how many cells the transposed data will require. Passport for macHope the content is useful.
0 Comments
Leave a Reply. |
AuthorAlyssa ArchivesCategories |