Transpose from rows into columns by using sql or pivot database function. Data preparation: Solution using SQL Solution using Teradata PIVOT function

Solution using regexp split to table Solution usineg SQL WITH RECURSIVE