•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Using Power Query to fill column
Our take
If you're handling a dataset with inconsistent formatting in Power Query, you can easily transform entries to achieve uniformity. For instance, if your venue data appears as "Simpsons,XX" with a blank city field, you can leverage Power Query's capabilities to fill in the missing city information and format it correctly. By applying a series of transformations, you can ensure that all entries follow the desired structure, enhancing data integrity across your 1,700 rows. Let's explore how to streamline this process effectively.
I have three columns that are venue, city and state so it might read:
Venue – Simpsons; City – Springfield; State – XX (proper format)
But some of the entries read like this:
Venue- Simpsons,XX; City -shows blank; State – XX
Above is a formatting issue from the source data that I cannot change.
Is there something I can do in Power Queries that will fix the SECOND example to be like the FIRST example?
I have about 1700 rows like this and its about 5 entries.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience