LinkedIn Microsoft Excel Certification

How can you create the lower table from the top one when the tables are not linked?

October 29, 2022 Editorial Staff

Select Paste Special > Values.
Select Paste Special > Transpose.
Use the TRANSPOSE function
Click Switch Rows & Columns

The correct answer is:

Select Paste Special > Transpose.

🎓 Get all the latest and 100% correct LinkedIn Microsoft Excel Skill Quiz Answers