Split columns where rows have different delimiters/ widths with PowerQuery
Автор: AuditExcel Advanced Excel and Financial Model Training and Consulting
Загружено: 2022-10-03
Просмотров: 369
Описание:
00:00 Convert text to columns where each row has different widths
00:10 Convert list to Table and import into Power Query
00:18 Irregular spaces makes splitting to columns problematic
00:44 First remove unnecessary rows (rows that DON'T contain our key row identifier)
01:05 With other rows removed, the field widths become apparent
01:20 Split column based on spaces
01:45 Dates/ times and amounts are in their own columns now
02:00 Correct the data type on the key columns
02:25 Replace points with commas to create a valid decimal number in Power Query
How to deal with a data set where we are interested in one part (faxes in this case) but it is mixed into other data and the rows seem to have different split points depending on what is on that row. In this case we need to first group like with like rows (deleting the other rows in this case) and then split the more consistent data set into its own columns.
Повторяем попытку...

Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке: