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

1. Select `Paste Special > Values.`
2. Select `Paste Special > Transpose.`
3. Use the `TRANSPOSE` function
4. Click `Switch Rows & Columns`

Answer: The correct answer of the above question is Option B:Select `Paste Special > Transpose.`