Forum Discussion
manoolya
Oct 13, 2022Copper Contributor
How to delete cells in one column expect the first one based on another column
Hi below is a sample of my data: https://www8.0zz0.com/2022/10/13/03/289351819.png For each city (example ABHA and AL HASA) for each day i want to delete the redundant day only keep the day ...
- Oct 13, 2022
Hi manoolya
With Power Query:
Group By [station_name] & [observation_date], aggregation = Max of [observation_time]