Transpose Cross Tables
The Tool Transpose Cross Tables allows you to transpose data lined up on rows in a crossed reference table, moving them in a single column maintaining a relation with those cells of one or more fixed columns from the original table whose data will be replicated vertically, having as a result a flat file database format.
In the case in which the table has a heading row, there is an option that allows its transposition into an additional column, labeling each row of the output table.
It is possible to reformat tables containing one or more fixed columns to the left and/or to the right hand side of those columns containing data rows to be transposed.
The outcome of such transposition will be created in a new workbook without affecting the original data.