Shorcut for past transpose excel mac3/15/2023 In case you want the transposed data to be dynamic, use the TRANSPOSE function as shown below. This means that in case the data changes, then you will have to repeat these above steps again to get the new transposed data. ![]() ![]() You will have to copy the formatting separately.Īlso, the transposed data is static. Note that when you use the above steps, it only transposes the data, but does not carry the formatting with it.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |