merge rows

[gsafaraliyeva]

 i have list of data and I want to merge rows just side by side without affect  on data, so basically i just want to make something like in excel, cut rows and paste in certain place. In my case just paste by rows side by side.Any suggestions?

[jankelleyfl]

Unless I am misunderstanding your question, what about the "Join" tool? You can join based on record position, allowing you to simulate pasting rows right next to other rows like in excel.

[gsafaraliyeva]

All my data is in the same sheet and i couldn't do it via join tool. Maybe you could provide more info. All my data in the same sheet and rows are under each other and i want them to be side by side.

[jankelleyfl]

Happy to! Are you able to supply your data (or similar dummy data) / workflow in addition to giving an example of which rows you want side by side? That will help me narrow down the best way to help you.

[apathetichell]

How would you describe in Excel terms what you want to do and the logical basis for how you implement the decision of what goes where?

It sounds a bit like you want to do a cross-tab where something stays static (is a key column) and other data becomes columns - but it also sounds like you might want to bisect your list and then put half of the rows just next to your other rows. You can do this via record id. filter out half your rows. unselect/drop that old recordid.  new record id on both halves of your rows form the filter tool. and then YES, a join will allow you to get your info side-by-side.

If neither of these are correct could you post a data sample and what you want that data too look like after your process?

[gsafaraliyeva]

This how my table looks like:

I have more than 100 rows and i want them to be just side by side

[apathetichell]

recordid/filter as described above.

[hellyars · Accepted solution]

@gsafaraliyeva It is not pretty, but this works.  Alteryx does not like fields with the same name.  In this example, I simply added a space -- but you might want to consider changing the name.