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.
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:
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:
On this step, you can select the columns with the entries to merge:
Click Finish to get the result transposed table on the new sheet:
Hi. How can I reverse the process? I mean, from your example I have the "Result" and I want the "Table 1".
Sorry, your task is not clear. For us to be able to help you better, please send us a small sample workbook with your source data and the result you expect to get to firstname.lastname@example.org. I kindly ask you to shorten the table to 10-20 rows.
We'll look into your task and see if our software can help.
After transposing the data by Key Columns, I then want to create a relationship or a link between the data should I make changes from the original or source table, the transposed has to change also. How do I achieve that?
Thank you for your comment. Please note that when Transpose by Key Column moves data, it changes formulas to values. That is why it is not possible to link the transposed table to the original one. To link the transposed and the original tables, try using a Pivot Table in Excel.
it does not work properly. i have a large amount data with above 4000 rows and 4 columns. after a specific row (different in other worksheets) the add-in only transform the first row in duplicated key columns. please fix it. for example we have a table that it has two rows with key column "alfa", three rows with key column "beta", three rows with key column "gamma" and two rows with key column "theta" ; the add-in transform correctly two and three rows with key column "alfa" and "beta" after that it transforms only the first row with key column "gamma" and the first row with key column "theta".
Thank you for the comment. For us to be able to understand the problem better, we need to know more details. Could you please send us a sample workbook with your data and screenshots of each step with the selected options to email@example.com? We will reproduce the issue and find the cause. Thank you in advance.
Post a comment
Seen by everyone, do not publish license keys and sensitive personal info!