Which operation toggles the data perspective from rows to columns?

Which operation toggles the data perspective from rows to columns?

• A. Switch
• B. Pivot
• C. Transpose
• D. Filter

Answer: (A)

Transposing data swaps the axes of a table so what was in rows becomes columns and what was in columns becomes rows. This directly changes the view from a row-based perspective to a column-based one, letting you treat former row data as individual columns and vice versa. It’s a straightforward way to rotate the layout of your data. Pivoting, by contrast, reorganizes data through grouping and aggregating values, often creating new columns from category values rather than simply flipping rows and columns. Filtering selects a subset of data based on criteria and doesn’t change the orientation of the table.

Transposing data swaps the axes of a table so what was in rows becomes columns and what was in columns becomes rows. This directly changes the view from a row-based perspective to a column-based one, letting you treat former row data as individual columns and vice versa. It’s a straightforward way to rotate the layout of your data. Pivoting, by contrast, reorganizes data through grouping and aggregating values, often creating new columns from category values rather than simply flipping rows and columns. Filtering selects a subset of data based on criteria and doesn’t change the orientation of the table.