Forum Discussion
Sorting imported rows
I have Teams data for members in our organisation. The issue with this data is if a user has no data for that day, they have no entry, which means the order is different each day. I need to impor...
IMHO, with Power Query it'll be easier. First you need to generate separate calendar table. If only dates, you may use List.Dates() function, for more complex cases there are a lot of samples how to generate Calendar. Merge it with your data on dates and expand values. Nulls will be for dates without data. Do cosmetic and return result into the Excel sheet.