Transpose Data Labels

The Transpose Data Labels tool allows the transposition of data blocks vertically aligned on columns and separated by one or more rows (as labels do on a sheet of paper) creating a flat file structure. Each block of original data will occupy a line (record) of the output data.   

This tool will perform transpositions to all those rows that will match the data pattern established by the user selecting those columns where labels are located, it is to say, the tool will not transpose those rows containing data in columns different from those selected by the user.

view demo