I have a large data table, lets say 100 rows and 20 columns. This is say a data table of student test results. The first column is the student names, the next 19 columns are if they got the question ...

When working with address data, you may encounter situations where you need to merge multiple columns, such as address, town, and postcode, into a single column. Power Query makes this task a breeze.