Is there a way to automatically normalize tables in calc ?

asked 2016-08-03 12:14:26 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Hello,

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).

image description

I want to have it normalized, such as below (cells are "transposed"):

image description

It can of course be done manually with "copy/paste transpose".

But is there a programmatic way (function, macro) to do this ?

edit retag flag offensive close merge delete

Comments

Is it safe to assume that you mean normalization as a Database concept? Then it is not used in your question because you are talking about spreadsheets(Calc). It is unclear from the question what you want to do. You want a new sheet with the above second table values? You want to be able to select the names of registrants from a static range of cells (which might imply some kind of "normalization")?

Xoristzatziki gravatar imageXoristzatziki ( 2018-06-03 04:52:29 +0200 )edit