0

My sheet

my sheet

What I want to do is simply combine these 2 rows of columns with different info like fish type and merge them into the column on the right where it says both, I managed to combine them but it has all the white spaces and I also need it to be sorted alphabetically.

I have tried fiddling with some filter functions but I am a bit clueless, just a bunch of errors

alea
  • 980
  • 1
  • 13
  • 18
Dav
  • 1
  • I have created this read-only sheet for this question. see [here](https://docs.google.com/spreadsheets/d/1wf5Za_TuiPYTa25gJIhCouYaxiy70XLK6EhasmKzsHg/edit?usp=sharing) – Abdullah Faqih May 29 '23 at 22:32
  • Does this answer your question? [how to find unique values from two different columns in google sheet?](https://stackoverflow.com/questions/62557330/how-to-find-unique-values-from-two-different-columns-in-google-sheet) – Tedinoz May 30 '23 at 00:33
  • No sorry I need all values not just unique ones! – Dav May 30 '23 at 09:17

1 Answers1

2

Try the following formula-

=SORT(UNIQUE(TOCOL(FLATTEN(A3:A,C3:C),1)))

enter image description here

Harun24hr
  • 30,391
  • 4
  • 21
  • 36
  • I need them all entries! Not just unqiue values, I forgot to specify sorry, do I just remove the unique tag for that? – Dav May 30 '23 at 08:53
  • @Dav Yes, just remove `UNIQUE()` function. Try `=SORT(TOCOL(FLATTEN(A3:A,C3:C),1))`. – Harun24hr May 30 '23 at 09:06
  • Im getting an error when trying to use it in my sheet here: https://docs.google.com/spreadsheets/d/12ZU6CowQ_2CEMhvworkkrWJ_NcdlNvi-/edit?usp=sharing&ouid=109507627592554463957&rtpof=true&sd=true – Dav May 30 '23 at 09:10
  • At the "old burg lake" tab – Dav May 30 '23 at 09:10
  • Are you on Excel or google-sheet? They are two different product. – Harun24hr May 30 '23 at 10:25
  • If you are on `Microsoft Excel 365` then use `=SORT(VSTACK(TOCOL(C7:C50000,1),TOCOL(L7:L50000,1)))`. – Harun24hr May 30 '23 at 10:28