Forum Discussion
Moving cell content from one column to rows based on an adjacent cell
Hello, I have a spreadsheet with two columns. Column 1 has text that is repeated as well as some terms that are not repeated. Column has text based on the text in column 1. I need a formula that ...
mjs-111 I have made a solution with some helper columns, attached. I have used the Office 365 FILTER and UNIQUE functions to populate the first two column of the transformed version, but you could paste-values and use Remove Duplicates to do the same if you don't have those.
