I have a table which looks like this:
A B C D 1 red blue green white 2 blue red white yellow 3 red blue green white 4 red blue green white
and would like to get a result like this:
col1 col2 col3 1 A red 1 B blue 1 C green . . 3 A red 3 B blue
It is kind of the opposite of the creation of a pivot table.
Is there any way on how do this with a function or plugin in Google Spreadsheet?