1.3.6. Shape data by using pivots Leave a Comment / By LearningTableau / November 1, 2024 Use the Data Analyst resource guide to find documentation related to this topic. More data analyst practice questions here. In Tableau Prep, which pivot option would you use to transform data from a wide format to a tall format, and how would you execute this transformation? Pivot rows to columns; select the fields to pivot and choose "Pivot Rows to Columns." Pivot columns to rows; select the fields to pivot and choose "Pivot Columns to Rows." Use wildcard search; enter a pattern to match field names and apply the pivot. Use the Aggregate step; group fields to adjust data granularity. None Which pivot type in Tableau Prep involves aggregation Rows to columns Columns to rows Wildcard Search None of the above None Time's upTime is Up!