Flash fill is an awesome tool which magically fills data once it identifies a pattern.
The tool justifies its name by executing a task that would normally take hours, in a “Flash”.
Combining the columns to make a complete address is easy, just input in the first cell, go to the next cell and press Ctrl + E
Now you can extract the pin code out of the same address
You can also edit the names as per a certain format or clean up the data by getting rid of extra spaces as seen below.
Instead of using the tedious and long formula with concatenate, you can use flash fill to do the same thing effortlessly as seen below.