In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Text to Columns (Even rows)

YXM1012
5 - Atom

I have a database with 3 columns (No. of records, SKU ID and Price). I noticed that all the odd rows have the information, but in the even rows, I have the "Product Name". So I would like to find a solution to convert the even rows as a column of the odd rows.

Input:

Yessica1_1-1613504375217.png

Output

Yessica1_0-1613504351220.png

Thanks for your support!

2 REPLIES 2
AngelosPachis
16 - Nebula

Hi @YXM1012 ,

 

Here is one way to do it

 

AngelosPachis_0-1613505163141.png

 

Hope that helps,

 

Angelos

YXM1012
5 - Atom

Many thanks for helping me! 🙂 

Labels
Top Solution Authors