SEVERELY STUCK , How to Split Multiple Columns into Row?

In power Query - and there are a few ways

Method 1 - both of these commands are available from the Ribbon and have wizards and help

1. Split Column using "," as seperator be sure to look under advanced options and choose every occourance and choose a number of colums larger than the maximum number of possible items
2. Unpivot these columns

Mehod 2 -  This will dynamically adjust to the maximium number or columsn and be future proof if more are added later but requires some M that I dont' think you can get from the ribbon

1. convert the comma separated list into a "List" Object,
   1. Add a custom Column
   2. enter this formula  where [List of Values] if your column containing comma separated list. Wrapping it in {} converts it to a list and then the Table.FromList converts it to a table

      Table.FromList({[List of Values]}))

2.  then exapand it using the expand icon on the top right of the column header of column contianing the table
3. delete the extra columns that were added.

Here is the M Code - you can create a new query from "Blank Query" and then past it in. you can then see how it works step by setp. 

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("JcqxEYAwDATBXj6+QC+ZArDL0Kj/Nhgg3dlu3UImKRaXhtZ+JXHhhX8733KQQYVmHg==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Row = _t, #"List of Values" = _t]),
    #"Added Custom" = Table.AddColumn(Source, "Custom", each Table.FromList({[List of Values]})),
    #"Expanded Custom" = Table.ExpandTableColumn(#"Added Custom", "Custom", {"Column1", "Column2", "Column3", "Column4", "Column5"}, {"Column1", "Column2", "Column3", "Column4", "Column5"}),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Expanded Custom", {"Row", "List of Values"}, "Attribute", "Value"),
    #"Removed Columns" = Table.RemoveColumns(#"Unpivoted Columns",{"List of Values", "Attribute"})
in
    #"Removed Columns"

Hi Chanleakna123,

Due to I could not figure out the name in your columns, could you please post me the file or picture with english?

Regards,

Daniel He