Is there a Google Sheets add-on/extension that can help me to achieve the following “unwinding” of rows in a table that contains columns with multi-valued data:

Column A Column B, multivalued
First A,B
Second C,D

It transforms the above to:

Column A Column B, multivalued
First A
First B
Second C
Second D

I can't seem to find any so far, or maybe I am not sure what is the right keyword ;(

  • Do you need it to replace the original data? If not (and this is the way spreadsheets are usually manipulated) then you can probably easily do this with a formula. Jun 20 at 15:20


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.