4.4 Rearranging, Filtering and Conditional Formatting of Data

Appending Worksheets to Single Sheet

Join Multiple Sheets by Column

Join Two Sheets by Column

Join Worksheets by Label

Splitting Worksheet into Panels using Dividers

Freeze Rows Columns

Splitting Worksheet into New Sheets

Sorting Worksheet Data

Stacking and Unstacking Worksheet Columns

Stack Worksheets by Column Label

Copy Columns to New Destinations

Sort Columns by Labels

Converting Worksheet Data to XYZ

Select or Hide Columns

Column List View

Split Columns

Worksheet Query - Quick Start

Pivot Table

Data Filter

Conditional Formatting

Unstack by Time Interval

Time Series Pivot