Table Entrty

[Jonlovett]

I'm new to Alteryx and code in general.

I have a table populated from 3 inputs that need to be grouped by the subfield column.
The data ideally needs to look as column 1 is the subfield, column 2 is the start bit1 (2 records down) and column 3 is the end bit 1 (again 2 records down)

I think it needs to be a multi row formula tool, but I can't figure it out.

[caltang]

Please provide relevant data to this use case, and kindly provide your criteria in as much detail as possible. If you have a workflow built halfway, kindly export that over as well.

[Jonlovett]

The input file and the section of the workflow are attached.

With the RecordID sorted numerically, the start bit and end bit cells are shown underneath in the correct order.
I want the subfield and corresponding start / end bit cells on the same row.

Many thanks

[caltang · Accepted solution]

Like so?