I have a use case where I need to merge all holders pertaining to a ticker in one cell as well as align their manager names across that particular holder (screenshots attached). The issue occurs when I concatenate values in the summarize tool (highlighted in blue). The output just concatenates all the manager names without aligning them to their respective holders. A method I tried, was to just add a formula tool and replace all null spaces under Manager1 with " " (three spaces in between). However, I'm guessing this is not the most efficient way of solving the problem. Would be great to know if there is a work around for this with my existing workflow in place?
Thanks!
