Correct Answer:
A. Transpose
The correct answer is Transpose. because the Transpose function in data management rotates data structural axes, turning horizontal row records into vertical column entries and vice versa.
- Step 1 (Data Transformation): Spreadsheet layout adjustments often require changing how datasets are oriented to improve readability or compatibility with analytic tools.
- Step 2 (The Operation): In applications like Microsoft Excel or Google Sheets, applying the Transpose command takes an array of horizontal entries and realigns them to fill vertical cells perfectly down columns.
- Incorrect Options:
- Pivot is incorrect because a Pivot table aggregates, calculates, and reorganizes summary metrics from data fields rather than executing a simple structural row-to-column flip.
- Filter is incorrect because filtering simply hides rows that fail to meet specified logical criteria without changing the physical cell layout orientation.
- Sort is incorrect because sorting alters the sequential order of records (e.g., alphabetically or numerically) while maintaining their original row or column alignment.