Method 3: TRANSPOSE Using INDIRECT function So follow along to learn some more easier to go tricks to get the data transposed in Excel. Therefore, even if it is good for many reasons, it is hard go by in many situations. So basically it is a live-transposed-range of the source-range.īut as this is an array function this is very much dependent on the source and if you try to change anything this tends to break. The best thing with using TRANSPOSE function is that if you change the values in the source range then transposed range will also change accordingly. TANGO! Your data is transposed! Benefit of TRANSPOSE Function Yes! Not just Enter key but Ctrl+Shift+Enter as this is an array formula Step 4: Write TRANSPOSE function following the equal sign and enter the data range that you want to transpose Step 3: Press F2 key to enter edit mode while the region still selected. Step 2: Select a vacant region in the worksheet which is 2 rows deep and 7 columns wide. Step 1: Determine the rows and columns of data. In our case it is 7 rows and 2 columns Once you transpose the data it will be 2 rows and 7 columns. For example you have 2 columns and 7 rows. IMPORTANT: Determine the rows and columns of your data. The use of this function is a little tricky and requires knowing more than pressing TAB so follow the steps closely. Yes there is a function that can do the somersault called TRANSPOSE. Told ya! it is easy! Method 2: TRANSPOSE Function to switch columns to rows or vice versa This will open the paste special dialogue from which check the transpose checkbox and click OK button
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |