I have a data set that looks like this
The problem over here is there is a pattern which clearly states that Field 1 corresponds to a record while the off numbered records corresponds to a column.
Something like this:
I have tried the transpose and cross-tab tools but I am not able to understand how to implement a logic that can go on every alternate entry and assign it as a column and simultaneously enter the record for those columns based on the record id it skipped.
I am pretty new to the alteryx tool and would like to get any help on this.
Solved! Go to Solution.
Hello @adutt1,
Hope this helps:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regards