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

Column into rows

BRRLL99
11 - Bolide

Hi

 

I have following data

 

BRahuL99_0-1663332913236.png

 

Expected Out-put:

 

BRahuL99_1-1663332950164.png

 

2 REPLIES 2
Luke_C
17 - Castor

Hi @BRRLL99 

 

There are a few ways to do this. Here's one example using the tile tool and crosstab. This would be dynamic if there are ever more than 3.

 

  1. Tile tool determines how many medicines are there for a given column A value & date
  2. Formula tool builds the header
  3. Crosstab formats how you want it

 

Luke_C_0-1663333693722.png

 

Christina_H
14 - Magnetar

I've done this using the Tile tool

Christina_H_0-1663333931557.png

 

By the way, it's better to provide tables or attachments with your sample data rather than images.  That way people can download or copy and paste the data rather than having to type it out.

Labels