Preview:
= Table.AddColumn(#"Removed Columns2", "The Auditor", each if [Lead Auditor] <> "" then [Lead Auditor] else if [Internal Auditor] <> "" then [Internal Auditor] else if [External Auditor Name] <> "" then [External Auditor Name] else "Unknown")
downloadDownload PNG downloadDownload JPEG downloadDownload SVG

Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!

Click to optimize width for Twitter