Forum Discussion

jcoe's avatar
jcoe
Frequent Visitor
9 years ago
Solved

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...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    jcoe

     

    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,

     

     

Back2Basics's avatar
Back2Basics
Icon for Resolver I rankResolver I
9 years ago

Based on wat you have said I would assume that the project or the service fields will always only have one entry between them - eg. if project is null then service has en entry and vice versa. If that is the case I have done the following:

 

Add New Column

 

Project/Service Description = if(Mytable[Project Type Description]=BLANK(), Mytable[Service Type Description], Mytable[Project Type Description])

 

 

There might be cleaner ways of doing this but I have found this has worked for me in a similar situation.