How to create multiple columns based on some conditions

[wcamarg3]

Hi all,

I hope anyone can help me.

I have a table which has the "Line", the "Operation" and the "Serial Number".

Line	Operation	Serial Number
A_ONE	10	123782
A_ONE	20	123783
B_ONE	20	123784
B_TWO	30	123785
C_ONE	40	123786

And I would like to create another columns segregated by the "Line" and "Operation" name containing the respective Serial Numbers inside these columns.

To better understanding follow below the desired output:

A_ONE OP10	A_ONE OP20	B_ONE OP20	B_TWO OP30	C_ONE OP40
123782	123783	123784	123785	123786

Thanks,

Wil

[AngelosPachis · Accepted solution]

Hi @wcamarg3 ,

You can use a formula tool to form the column headers and then cross tab your table to get the desired output

Hope that helps,

Angelos

[atcodedog05 · Accepted solution]

Hi @wcamarg3 

Here is how you can do it.

Workflow:

1. Using formula tool to create new column name.

2. Using formula tool to convert serial number int datatype to string.

3. Using crosstab tool to convert to table.

4. Using dynamic rename to fix the names.

Hope this helps : )

[wcamarg3]

Thank you @AngelosPachis!

[wcamarg3]

Thank you @atcodedog05

[atcodedog05]

Happy to help : ) @wcamarg3 

Cheers and have a nice day!