Reshape data long to wide in MySQL

I have a table that I want to pivot/reshape from long to wide. The long format has 3 columns: zipcode, category, zipnum ‘12345’, ‘A’, ‘1’ ‘40348’, ‘A’, ‘2’ ‘16132’, ‘B’, ‘1’ ‘09428’, ‘B’, ‘…