Grouping Rows ("conditional copy") from different tables in LibreOffice Calc

1
votes

I want to group the students of some classes into different groups at school using LibreOffice Calc.

I already have tables for all classes, where I entered the group (1-3) of every student:

ClassA

What I LibreOffice want to do now, is to copy all students of all classes, which are in group 1 (group 2, group 3, ...), into one new table (Group1). Then, I have one list with the students for every group.

In this example, it would be Name1 and Name6.

I searched the web for hours and played around a lot without success.

Any help is appreciated!!

1
libreofficelibreoffice-calc
You mention in a comment that you have multiple tables for different classes. I'd recommend keeping all the classes in one table - add a column "Class" to the table. Then maybe look into VLOOKUP. See VLOOKUP questions and answers - Lyrl

1 Answers

2
votes
  1. Select the data cells A1:B8;
  2. Menu Data -> Standard Filter...
  3. In the standard filter window, set the filter properties as follows: enter image description here
    1. Field Name: Group; Condition: =, Value: 1 (or select from dropdown);
    2. Click on Options
    3. Select "Copy results to"; enter the target: $Group1.$A$1
  4. Click OK