Forum Discussion
jcoe
9 years agoFrequent Visitor
combine data into one row
Hi, I've been trying to figure this out and so far nothing I've come across has seemed to address my specific issue. I'm trying to combine my data based on the "Task Name" column, keeping the in...
- 9 years ago
You can go to Query Editor, select both "Project Type" and "Service Type" columns, click "Group By" to have records group by all other columns and specify aggregation for these two columns. See my sample below:
Regards,
v-sihou-msft
9 years agoMicrosoft Employee
You can go to Query Editor, select both "Project Type" and "Service Type" columns, click "Group By" to have records group by all other columns and specify aggregation for these two columns. See my sample below:
Regards,
kymramosrpo
3 years agoAdvocate V
What a neat, easy-to-follow solution! Thank you so much!