Forum

Thanks, Mynda. Would you be able to please provide a link to post that explains dynamically referencing columns by number or a list of column names...

Thanks so much, Mynda. This solution works perfectly.

Hello again, I figured this out. By Adding Custom Column, and entering the formula: ={"NSW","QLD","VIC","SA","WA"} However, this leads to anot...

Thanks so much, Mynda. This is exactly what I was looking for. Regards, Danielle

Thank-you so much!

Hello again, I think I've worked out the solution, using conditional column. Thanks, Danielle

Thank-you, Philip.

I assume it would be the same case for postcode formats? That is, for NT, postcodes have a leading zero, which is cut off, when loaded to Power Query...