Summarize many columns in MySQL
SQL newbie. We have a dataset which is sourced by a google-doc. The data has many columns with short strings in them. Our goal is to summarize it to two columns Column 1: Order Number Column 2: A concat of each column on a given row (with the column headers prepended in) I have created a transform that extracts all of the…
