Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to join cell rows in one cell

Sshasnk
8 - Asteroid

So I have multiple excel files with different formats and I have to standardize them into one single format.

Attached is the excel where sheet1 and sheet2, I have to merge them and merge them. I have also attached the output in the same excel sheet

Let me know if anyone has any questions

 

 

 

 

 

3 REPLIES 3
binuacs
20 - Arcturus

@Sshasnk Interesting use case. One way of doing this

binuacs_3-1662666847422.png

 

 

 

 

 

Sshasnk
8 - Asteroid

the format of sheet1 could be in sheet2 and sheet2 in sheet1, So you will never know 

binuacs
20 - Arcturus

@Sshasnk updated the workflow

 

binuacs_0-1662670937877.png

 

Labels