Let's say you want to group multiple values together into a single value.
E.g. you have a column containing countries and want to treat Canada and the US as one single value called North America.
(1) Click New Column
(2) Give your column a name (e.g. region)
(3) Add the following expression:
if (country == "United States" or country == "Canada") then "North America" else country.
*change country to the name of the column containing the country values.
(4) Click Done.
All done! 👨🚀
You now have a new column that contains "North America" in rows where the country is Canada or the United States!
(In SQL, you would do the above using a Case Statement)