Forum Discussion
Power Query CSV File is not in a usable format
Hi davidwhite83
One more step. In those columns that have blanks rather than null, you have to highlight the column and perform Find and Replace. Leave the Find box empty and then type null into the lower box. All lowercase, no quotes. This should do it. What is strange is that just typing it into your source table does not work. Let me know how this goes.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Hi davidwhite83 ,
If I understand correctly, starting from the bottom, you have a set of rows that you wish to align with the lower set of values. When you bring the file into Power Query there should be some null values. By going to the Transform tab, and clicking Fill Down, you will be able to fill in those lower rows. Then going back to the Home tab, Remove Rows, Remove Top Rows you will be able clean up the file. Check out M is for Data Monkey by KenPuls . A great book for all this sort of clean up and more.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
It works on the number portion of the file but not with names.
Hi davidwhite83
One more step. In those columns that have blanks rather than null, you have to highlight the column and perform Find and Replace. Leave the Find box empty and then type null into the lower box. All lowercase, no quotes. This should do it. What is strange is that just typing it into your source table does not work. Let me know how this goes.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel