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