In calc I want to “normalize” a table.
Here is an example:
I have a table with registrant who enrolls from 1 to up to 4 participants (enrollees). It is not “normalized”, because there is e repeating column (Name Enrollee).
I want to have it normalized, such as below (cells are “transposed”):
It can of course be done manually with “copy/paste transpose”.
But is there a programmatic way (function, macro) to do this ?