• Manipulate Data in Worksheets, Columns, and Rows
How-To
  • Using worksheets
  • Format columns
  • Subset a worksheet
  • Split a worksheet
  • Stack worksheets
  • Merge worksheets
  • Unstack columns
  • Stack columns, blocks of columns, or rows
  • Transpose columns
  • Sort data
  • Rank
  • Apply conditional formatting to cells
  • Recode values
  • Change the data type of columns
  • Round or extract date/time components
  • Concatenate text values