Greetings,

Struggling to figure something out. Thank you for your help...

I have a column of 1200 fields. examples are "item 1", "item 2"... the big
goal is to get one list that says "order item 1", "receive item 1", "install
item 1"...

So, I can use the concatenate function to generate columns of "order item
1", "order item 2" or "receive item 1", "receive item 2".

Now trying to combine these lists so i get one long list where all of the
actions for item 1 are listed first, then all actions for item 2 are
listed....

Is there a function that accomplishes this? Or, am I thinking about this
wrong?

Thanks for your advice!

Cheers,

Scot B