Split columns by delimiter in Excel Power Query

Опубликовано: 04 Октябрь 2024
на канале: AuditExcel Advanced Excel and Financial Model Training and Consulting

319

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.