4.4 Rearranging, Filtering and Conditional Formatting of Data
Rearranging-Filtering-Conditional-Formatting
Topics covered in this section:
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
4.1 Workbooks
4.2 Worksheets
4.3 Worksheet Columns
4.5 Formatting Worksheet Data
4.6 Simple Manipulation of Worksheet Datasets
4.7 Inserting Graphs Images and Other Objects into Worksheet Cells
4.8 Reference
4.4.1 Appending Worksheets to Single Sheet
4.4.2 Join Multiple Sheets by Column
4.4.3 Join Two Sheets by Column
4.4.4 Join Worksheets by Label
4.4.5 Splitting Worksheet into Panels using Dividers
4.4.6 Freeze Rows Columns
4.4.7 Splitting Worksheet into New Sheets
4.4.8 Sorting Worksheet Data
4.4.9 Stacking and Unstacking Worksheet Columns
4.4.10 Stack Worksheets by Column Label
4.4.11 Copy Columns to New Destinations
4.4.12 Sort Columns by Labels
4.4.13 Converting Worksheet Data to XYZ
4.4.14 Select or Hide Columns
4.4.15 Column List View
4.4.16 Split Columns
4.4.17 Worksheet Query - Quick Start
4.4.18 Pivot Table
4.4.19 Data Filter
4.4.20 Conditional Formatting
4.4.21 Unstack by Time Interval
4.4.22 Time Series Pivot