This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I need to combine rows into one based on few criteria, attached is sample of my data, I've played around with the summarize tool as that's I think I need to get this done but haven't had any luck.
Row 2 in orange is my main row as that's where column B matched to column D entries, that's the column I want to keep. I'd like to somehow bring in a count of applications in column M and have it as number (green cell). The tricky part is row 3, where there will be no match of the job ID to campaign ID but I still need that row to be shown as well. I have more visual explanations in column K if this does not make sense.