Obtaining a Flat Table from Pivot Tables
data frame col and row names
Define the quantity of rows and columns that contain labels
Divide table
Extract labels
Fill in missing labels
Fill in missing values
Fill in missing values in a vector
Remove top rows from a pivot table
Transform a pivot_table object list into a flat table
Get column values
Get the page information of a pivot table
pivot_table S3 class
Import Excel file
Remove right columns from a pivot table
Import one sheet from each Excel file in a folder
Import Excel file sheet
Import text file
Import all text files in a folder
Remove rows from a pivot table
Remove rows and columns with aggregated data
Remove bottom rows from a pivot table
Remove columns from a pivot table
Remove empty rows and columns from a pivot table
Remove thousands separator
Remove left columns from a pivot table
Replace decimal separator
Set page information to a pivot table
Spacer columns
Spacer rows
Unpivot a pivot table
Transformations that allow obtaining a flat table from reports in text or Excel format that contain data in the form of pivot tables. They can be defined for a single report and applied to a set of reports.
Useful links