I have below table, where I am trying to merge the columns in yellow in one column, while maintaining the original columns; the data in the highlighted yellow columns is populated based on the interaction type they fall into if the interaction type is null that means it doesn't fall into the interaction type category:
Would appreciate any help or guidance on how I can approach this