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?
@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.
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.
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.
