Hello all,
I have a number of columns on a spreadsheet (effectively, a table), each containing a range of text values.
(I believe / hope! that each text value is unique).
I want to create a single, separate column on this spreadsheet, which:
- takes all of the text values from the table, and
- puts them in alphabetical order, into this separate column.
All of the Google searches I've carried out only show how to sort a single, existing column, into alphabetical order.
Which, as the data I need to sort is across four or more columns, is useless to me.
Thanks in anticipation
I have a number of columns on a spreadsheet (effectively, a table), each containing a range of text values.
(I believe / hope! that each text value is unique).
I want to create a single, separate column on this spreadsheet, which:
- takes all of the text values from the table, and
- puts them in alphabetical order, into this separate column.
All of the Google searches I've carried out only show how to sort a single, existing column, into alphabetical order.
Which, as the data I need to sort is across four or more columns, is useless to me.
Thanks in anticipation