excel-university.com
FlashFill is an Alternative to CONCATENATE and Text-to-Columns
Have you ever split one column in to many columns, or vice versa, combined many columns into a single column? If so, you have likely relied on the text-to-columns feature to split a single column …