In the following data tables, Header1 field stores index numbers and there could be duplicate values. As the following shows, there are several 101 (highlighted in the red boxes) in each Header1 field:

We want to rearrange data in sheet data by the order of data in sheet Target. The rule, take 101 as an example, is that the first 101 corresponds to the first record where Header1 is 101, the second 101 corresponds to the second record where Header1 is 101, and the third 101 is recorded as an empty row because there isn’t a third matching record in sheet data.

SPL script:

A1 Import data of sheet Target, and add a new column named key to generate key values to which records in sheet data will be aligned.
A2 Import data of sheet Data, and add a new column named key to generate key values to which records in sheet Target will be aligned.
A3 Group A1 by Header1, loop each group and each record in the group, and assign values to key field – which are Header1 value + an underlined character + its ordinal number in the group.
A4 Same as A3.
A5 Align A1’s key to A2’s key.

Execution result: