![]() ![]() Select your data > go to the Power Query tab (Excel 2016 see Get & Transform on the Data tab).Power Query is available in Excel 2010 onwards so this technique isn’t for everyone (sorry 2007 users). If the size of the source data expands or contracts you have to manually update the formula. I like to cheat a little and use the Copy > Paste Special > Transpose technique in step 1, and then with the pasted cells selected simply overwrite them with my TRANSPOSE formula.ĭon’t forget to press CTRL+SHIFT+ENTER to complete the formula. ![]() Tip: The trick here is knowing how big the range needs to be. Where ‘array’ is the range of cells you want to transpose.įirst select the cells you want to place your transposed data in. The TRANSPOSE function only has one argument: =TRANSPOSE(array) TRANSPOSE is a multi-cell array function and as such you enter it with CTRL+SHIFT+ENTER like any other array formula. Use a formula like the built in TRANSPOSE Function That means if the original data is updated you’ll have to do the whole Copy > Paste Special > Transpose all over again, and manual repetition is Excel blasphemy. It’s really only good for one-time use since it’s not linked to the original data. The downside of Paste Special > Transpose xlsx file please ensure your browser doesn't change the file extension on download. Excel for Customer Service Professionalsĭownload the Excel Workbook. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |