A sales table has Jan, Feb, and Mar amount columns. Reporting requires Month and Amount columns while preserving CustomerID. What should you do?

Published
  1. Transpose the entire table
  2. Unpivot the month columns
  3. Pivot CustomerID
  4. Remove duplicate customers

Comments — 0