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.
SOLVED

Data in columns but need to be transposed to rows (sets of three rows in three columns)

Taxguy03
9 - Comet

Hi Experts, 

 

Need your help with the data presentation. We have data in columns with IP addresses. Every three rows need to be in three columns. We have attached a sample file with an example of the data presentation (how we want to data to look like = After). 

 

Any help will be appreciated. We hope to hear from you soon. 

 

Taxguy03_0-1627524896747.png

 

2 REPLIES 2
BrandonB
Alteryx
Alteryx

I used a couple of Multi-Row tools to establish groupings and a sub-record ID within each grouping and then finally a crosstab. Workflow is attached for reference

 

BrandonB_0-1627530514444.png

 

Taxguy03
9 - Comet

Thank you so much, BrandonB. It's exactly what we needed.

 

Have a great night. 

Labels