FLATTEN function can be used to convert semi-structured data such as JSON into a relational representation of rows and columns by creating a flattened view. It essentially transforms nested data structures into a tabular format, which aligns with the procedure of converting semi-structured data into a row and column format.