![]() ![]() In real life, you might need to do calculations instead of copying the data. If cells in column A change, they will change in row 2.Īdditional Details: The example in this topic is a trivial example of merely copying the cells. The advantage of using TRANSPOSE over using Paste Special, Transpose is that the TRANSPOSE function is a live formula. A single TRANSPOSE function fills in these cells.Excel will add curly braces around the function, and the seven values will appear across your selection. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |