Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
126
Views
Topic starter
Hi,
I am trying to import the data below, but seldomly data in row skips/moves two columns to the right(Row 2and 16). I am kinda stuck as to how move that data back to left. I attached the text fille
Any help would be greatly appreciated. Thanks
Posted : 09/02/2022 7:53 pm
Hi Esteban,
Welcome to our forum!
Thanks for sharing your file. Duplicate the query, then filter the third column to keep just the rows that contain 'Block'. Clean those rows to remove the duplicate information, which is the first two columns, then append it with the original query.
Hope that points you in the right direction.
Mynda
Posted : 11/02/2022 6:48 am
