Aggregating Visitor Data in Clay: Groupby and Pivot Table Alternatives

Hi - Is there a groupby or pivot table equivalent on clay? I have a claytable which has all website visitor information for me however it has multiple rows of information for each visitor based on how many sessions have they done. I want to aggregate that data onto another clay table where each unique row is for a unique visitor. Appreciate the help 🙏