CompTIA Data+ (DA0-001) — Question 279

An analyst wants to combine two data sets into a single spreadsheet. Column names from the first spreadsheet are listed in rows in the second spreadsheet. Which of the following is the first step the analyst should take to combine the data sets?

Answer options

• A. Blend
• B. Merge
• C. Concatenate
• D. Transpose

Correct answer: D

Explanation

The correct answer is D. Transposing changes the orientation of the data, allowing the analyst to convert the column names from the first spreadsheet into a format that can be matched with the second spreadsheet's rows. Options A (Blend), B (Merge), and C (Concatenate) are not appropriate initial steps as they do not address the need to rearrange the data layout first.