Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
I am experiencing an offset in columns from some rows, I don't know how to handle it with Power Query
Thanks
https://1drv.ms/x/s!AoqtZHsX4BzvhddJ5qr_fWw_fwQLjA?e=xM73DO
Solved! Go to Solution.
Demo attached. Maybe you can try below steps:
1. Add a [Index] column to your table
2. duplicate the orginal table
- distinguish the two table by [Index], the first one with [Index] less than 4 and the second one greater than 4
3. Remove blank column in the first table and rename columns in the second table
4. Append queries, so you'll have a consolidated clean table.
Best Regards,
Joyce
Demo attached. Maybe you can try below steps:
1. Add a [Index] column to your table
2. duplicate the orginal table
- distinguish the two table by [Index], the first one with [Index] less than 4 and the second one greater than 4
3. Remove blank column in the first table and rename columns in the second table
4. Append queries, so you'll have a consolidated clean table.
Best Regards,
Joyce
effective
No as beauty as i was meaning
Good job