Tabulating to get the number of columns equal to the max distinct # of values in a column

[Annoushka]

Hi, 

I'm trying to create a set of columns (Procedure Name 1, Procedure Name 2, Procedure Name 3 etc), which number is the maximum number of the distinct values of a field. The thing is I don't want to use a Cross Tab where I have to select a field for new columns names, I just need to move all Procedures for one Schedule from one field to the several separate. The only way I created so far is to use a uniques field. But this option will not work when I have a bigger number of non-unique values. 
I would appreciate any ideas. 

[atcodedog05]

Hi @Annoushka 

Can you provide us a sample data.

[Annoushka]

Sorry, I attached the workflow to my post. There is just a short text input to get the idea of the data I work with 

[atcodedog05 · Accepted solution]

Hi @Annoushka 

I dont know whether you have tried this approach. Its dynamic do give it a look.

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[Qiu · Accepted solution]

@Annoushka 
Similar to @atcodedog05 , but not same. One more tool though...

[Annoushka]

Thanks a lot @atcodedog05 and @Qiu! Both decisions are cool! Exactly what I needed 🙂  

[atcodedog05]

Happy to help 🙂 @Annoushka 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂

[Qiu]

@Annoushka 
If you find it useful, appreciate you would mark as accept as well.😁