Solved! Go to Solution.
Each row is not meant to represent a separate record, correct?
If that is the case, I'd suggest isolating each column (field) using a select tool and then using a filter tool to remove all of the blank/null rows out. You can then use the join multiple too with "join by record position" as the configuration.
See attached for an example. Let me know if that works!
I should have mentioned that there are about 100 skill columns. do you still think that's the way to go? Thank you!
Hi @ozdogand If you transpose your columns, then you can filter out the empties, create a new rowid and then cross-tab the data back
Hope that helps,
Ollie
Brilliant. Thanks!