Forum Discussion
Grouping Data based on specific string
I have a column called name and the data entry is like this: YYYYYY-WRLD-TEAMS-TYPES / name the format is always the same with the same number of digits before the /. I need to group based o...
thanks for the reply .. it's characters in the middle
YYYYYY-WRLD-TEAMS-"TYPES" / name
also looks like I don't have access to use Power Query Editor ,so will have to ask an admin to create for me.