Forum Discussion
Combine data from 2 columns into 1 column
I want to do this, but with 2 columns of data. We have a sheet with area codes in one field and phone numbers in another. I need the 2 pieces of data in one field for a list of 500 phone numbers. ...
Hey all I used it by using "Flash Fill" - here is the example video that helped me: https://www.youtube.com/watch?v=1-U4RAj9qec
Link is correct, something is wrong with Microsoft servers or channels. Breaks even on root of support
If refresh from time to time it could appear.
Anyway, formula in general shall work.
You may see formula text instead of the result if Show formula is ON
Flash Fill is good enough, but please be careful with it. Sometimes it could give wrong results, especially on big data arrays.