Sort by the column headed "Group," then by "Name." Make a copy of the sheet
(right click tab name and follow prompts). On the original sheet, delete all
the entries from group 2; on the copied sheet, delete all from group 1.

"ccostas" <ccostas.at@.teipir.gr> wrote in message
news:1142425976.577318@athnrd02...
> Hi
>
> I have a table with 2 columns: Name and group
>
> Name Group
> John 1
> Dan 2
> Ron 2
> Jenny 1
> Jil 1
>
> How do I make two new tables from the original one based on the group ie.
> one table should contain only the names from group 1 and the other from
> group 2.
>
> Of course my real table consists of hundreds of entries
>
>
> Many thanks
>
>
>