I would probably start the data import on row 2 to skip the group names, then branch the workflow off into two separate select tools. The first select tool you should deselect the last three titles and the second select tool you should deselect the first three titles and make sure it that the second set of titles is named consistently. Then use a formula tool after each of the select tools. Create a new column called Group and set the value to “A” for the top formula and “B” for the bottom formula. Finally you can connect the results of both of the formula tools in the different streams together with a union tool. This should stack the resulting data together and get you the format that you need.
|