Does anyone have an idea on how to correct the flash fill option? In the column entitled “company name”, I want to combine secondary first and secondary last name. I’m using the flash fill option but as you can see in cell E6, Excel is flash filling Primary last name (which I don’t want). I only want to combine secondary first name and secondary last name. I can’t use formulas to combine the names as the software that I upload the data to doesn’t read any cells with formulas properly. Any help is appreciated!
Got it! The flash fill option was reading the primary first name column so I hid that column and used the flash fill function as normal. It now filled the appropriate columns correctly. I then unhid the primary first name column.