Join/Concatenate first 3 and last 3 values from the same column

[cito]

Hello folks,

I am newbie with Alteryx and I have one question.

So, my data looks like the table below:

and I would like to re-shape the data to JOIN first 3 and last 3 (based on the line_nbr) text values in the following format:

Any idea how to do this?

Thank you in advance.

[Luke_C · Accepted solution]

@cito 

Here's one approach using the sample tools to get the first and last 3, then union them, transpose, crosstab, and split back out to get the desired format. Let me know if this works for you.

[cito]

@Luke_C- Wow, works like a charm. Thank you very much!