Google Sheets - Basic data cleanup

Using TRIM(), UPPER(), LOWER(), PROPER() and how to combine values from multiple columns.