Forum Discussion
Solved
See attached
I am not able to post this, maybe it will post eventually. It keeps asking me to correct highlited errors but cant find any
- Try this formula if you have MS365:
=TOCOL(TOROW(TOROW(TOROW(TOROW(A1:A5)&"-"&B1:B5)&"-"&C1:C5)&"-"&D1:D5)&"-"&E1:E7)
Also, I think you can just edit this post instead of creating a new one.
Creating new posts creates confusion.
I had to look at both of your posts to figure out that you don't need to SORT numbers by "ascending order" explicitly, as numbers in column 2 is always greater than numbers in column1, column 3 is always greater than column2....
All you need is just combination.
I had to use Safari, I had tried a thousand time in google chrome and it would not work.