00:00 Split columns into own columns based on character with PowerQuery
00:12 Load the single column into PowerQuery
00:26 Split column at the dash "-", Comma ",", Semi Colon ";" and more
00:56 Split at first delimiter only (left most), last delimiter only (right most) or every instance
01:30 Automatic step of changing the type once in own columns can lose leading zeros
02:00 How the data types are changed in Excel can cause loss of leading zeros
02:13 Add a prefix for leading zeros
02:38 Split a column based on hashes (contents if different lengths)
03:30 Split a column by the space delimiter
03:45 Bank account numbers lose leading zeros when imported into PowerQuery
Use Excel's PowerQuery to split a single column into multiple columns by splitting the contents at a common delimiter such as a comma, space, tab or other item. Important to watch out for what happens with Power Queries automatic change type as it can often result in issues with losing leading zeros.
Split columns by delimiter in Excel Power Query
Теги
Split columns in Excel Power Querysplit column by delimitersplit columnsplit column by delimiter excelsplit column in excelpower query split columnspower query split columns by positionpower query split multiple columns into rowspower query split multiple columns at oncepower query split list into columnspower query split multiple columns by delimitersplit multiple columns power querypower query split rows to columnssplit all columns power query