Hi to all.
I need to fill the columns: Name Month Week by using the data in the Grouping column.
1. Only Plate numbers must be copied to the Name column.
2. Name of the month eg July must be copied to the Month column if Name column is not empty
3. Name of the week eg Week 26 must be copied to the Week column if the Name column is not empty
4. If the Name column is empty - the whole row must be deleted.
5. In the end, the Grouping column must be deleted.
I need to fill the columns: Name Month Week by using the data in the Grouping column.
1. Only Plate numbers must be copied to the Name column.
2. Name of the month eg July must be copied to the Month column if Name column is not empty
3. Name of the week eg Week 26 must be copied to the Week column if the Name column is not empty
4. If the Name column is empty - the whole row must be deleted.
5. In the end, the Grouping column must be deleted.