Pull Linked Record in order

I feel like this question has been asked before, but I cannot find an answer or post that really applies.

I have a form where users can input/sort options from one table (a hacked ranking system). Once they the form is submitted, I then want to figure out an automattion using basic text fields, or have multiple formula fields pull the records 1 by 1 into the separate fields in the order they’ve been input by the user’s form submission.

A, B, C record order

Field 1 = A
Field 2 = B
Field 3 = C

I’ve looked at arrays, converting to strings, tried the string lengths by using the shorthand info, this seems like something I used to do all the time in others, but it’s very clear arrays of data are not well managed in this?