Split columns by delimiter in Excel Power Query
на канале: AuditExcel Advanced Excel and Financial Model Training and Consulting
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 онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь AuditExcel Advanced Excel and Financial Model Training and Consulting 27 Сентябрь 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 319 раз и оно понравилось 2 людям.