Combine addresses into 1 line
This is example of the excel sheet you will get after export from system, some other system might need only 1 line of address, here is how you should do it like a pro!
| shippingAddress1 | shippingAddress2 |
| 1 Harimau Street #02-16 | |
| Blk 3000A Bukit badak street 25 | #22-58 |
| 100 Tigerlands Ave 5 | #04-02 Bellewoods |
| Bukit Tiger west ave 4 blk 407 #04-100 | |
| Harimau Central Blk 220B #04-38 | |
| Blk 36 Jalan Rumah Panjang | #21-5000 |
| 80 Lowview Avenue , #08-05 | Singapore |
For those who needs to separate out the combined address into 2 column, you can refer to the following video