Transpose data by sequence number

[amulp]

Hi all,

Looking for a way to easily flip data that's in one column into separate columns based on an order number. Essentially trying to get data that's in a format like Table 1 into a format like Table 2.

Thanks!

[Table 1]

[Table 2]

[christine_assaad]

Hi @amulp 

Please see attached and below. The idea here is to create a unique ID for every .group of records,

If this helped you. Please accept as solution. Cheers!

[amulp]

Perfect, thank you!