I need your assistance as I get familiarize with Tableu Prep...
I have a data set that looks something like this:
x Coffee / Tea
By using split I was able to produce the following
Company Product Split1 Product Split2
X coffee Tea
Now I need a way to consolidate all the splits in single rows
You need to use Pivot Stage and then filter out records where value is null.