Forum Discussion
Solved
Merge rows contain different values
I've got a problem with merging some rows. Bad issue with geting data brings me two different rows, (which are really the one) contains two part of information. For instance, this one. Here you ca...
You could do this a few ways.
I would start by creating a key by using split delimeter right most | on campaign.
You can then create two references for the 2 types of row. Filtering each with the 2nd part of the split.
Finally merge them together again with the key and expand the 2nd tables columns.