You have a Form Response spreadsheet with answers to "What language or languages do you want to learn?". Respondents could choose up to four languages. In total, 15 unique languages were selected in 102 selections spread across the four columns.
You want to "sort the same data's into columns. For example: Spanish in the same column, English in the same column, Chinese in the same column." You don't explain how or why this data would be used, nor do you provide an example. However you do have a chart of "What language or languages do you want to learn?", and presently this includes only one of the four Language columns.
This answer provides an alternative method to populate the data for the "What language or languages do you want to learn?" graph.
- Create a new sheet,
- Insert the formula in cell A1
- Edit the "data range" for the graph to reflect the output from the query
'Form Responses 1'!AB2:AB;
'Form Responses 1'!AC2:AC;
'Form Responses 1'!AD2:AD;
'Form Responses 1'!AE2:AE
"select Col1, count(Col1)
where Col1 is not null
group by Col1
order by Col1
LABEL count(Col1) ''",0
Revised Languages Graph
How can I create a unique list of data across multiple rows AND columns?