Unpivot Grand totals
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses6_topic3-unpivot-Grand-totals.odt” comments=”true” SVG=”true”] You can download your data files here C06E05
Pre-Append Preservation of Titles
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses5_topic2-Pre-Append-Preservation-of-Titles.odt” comments=”true” SVG=”true”] You can download your data files here C05E02 – Bikes
Unpivot selected columns
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses6_topic2-unpivot-selected-columns.odt” comments=”true” SVG=”true”] You can download your data files here C06E03
Custom Column Technique to Preserve Context
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses5_topic1-Custom-Column-Technique-to-Preserve-Context.odt” comments=”true” SVG=”true”] You can download your data files here C05E02 – Bikes
Combining tables with mismatched columns with a large number of columns
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses4_topic2-Combining-tables-with-mismatched-columns-with-a-large-number-of-columns.odt” comments=”true” SVG=”true”]
Combining tables with mismatched columns manual approach
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses4_topic1-Combining-tables-with-mismatched-columns-manual-approach.odt” comments=”true” SVG=”true”] You can download your data files here C04E04 – Products
Appending worksheets from a workbook
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/Ses3_topic4-Appending-worksheets-from-a-workbook..odt” comments=”true” SVG=”true”] You can download your data files here C03E01 – Accessories C03E01 – Bikes
Append forth table using the formula bar
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/Ses3_topic3-Append-forth-table-using-the-formula-bar..odt” comments=”true” SVG=”true”] You can download your data files here C03E01 – Clothing
Appending three or more tables
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/Ses3_topic2-Appending-three-or-more-tables.odt” comments=”true” SVG=”true”] You can download your data files here C03E04 – Year per Worksheet
Append two tables into a single table
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/Ses3_topic1-Append-two-tables-into-a-single-table.odt” comments=”true” SVG=”true”] You can download your data files from here C03E01 – Components C03E01 – Bikes C03E01 – Accessories