It is typically used to convert a trend report to transactional format for uploading into a database.
Pick Columns – select all of the columns to be unpivoted by position (column letter) or By Name. For every non-blank cell, a row will be created with the column name and cell value.
Column Title for Column Names – enter a name for the column that will hold the names of the columns in the original table.
Column Title for Cell Values – enter a name for the column that will hold the values from the cells in the original table.
ZZZ Last Column – select the special column ZZZ in the list if the data may change over time and you want to include any extra columns to the right of those already selected, should they appear.