PREMIUM
Join our WhatsApp Channel
Daily MCQs, Past Papers & Jobs for PPSC, FPSC, CSS
Daily MCQs • Past Papers • Jobs for PPSC, FPSC, CSS
Join Channel

Which function displays row data into column or column data into row?

A. Transpose
B. Pivot
C. Filter
D. Sort
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.
0 comments

Leave a Reply

Join Our WhatsApp Channel ×