Transpose by Key Columns is an add-in for Microsoft Excel created to transpose data in the selected range by the chosen key columns and simultaneously combine rows if needed.
The add-in searches for duplicates in key columns. If duplicate values are found, the tool transposes and/or merges data according to the options you choose.
For example:
Please note the following:
On the Ablebits Tools tab, in the Transform group, click the Transpose by Key Columns icon:
On the first step, the add-in picks the entire range with your data:
Click Next.
On this step, you can see a list of the columns your range contains:
Pick one or more key columns—the columns which contain duplicate values. Data will be transposed and merged according to the repeated values in the key column(s):
If you select more than one column, a record will be considered duplicate if values in all the selected key columns are the same.
Click the Next button.
On this step, tick off the columns to transpose:
For example:
Click Next.
On this step, you can select the columns with the entries to merge:
For example:
Click Finish to get the result transposed table on the new sheet:
Please contact us here