0

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 ;(

Improve this question
1
  • 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.
    – Yisroel Tech
    Jun 20 at 15:20

0

Reset to default

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.