deal with a pattern in file

[adutt1]

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.

[afv2688 · Accepted 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