Alteryx Designer Desktop Discussions

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

Split Multiple Rows with empty values into Columns

jcardoso
8 - Asteroid

Hi,

i'm trying to output the below result, but looking at some posts and banging the wall, decided to ask for help.
The intention is to output the upper rows, Region and Country, as columns. A pic with the Intended result is attached, as well as the workflow. The intention is this to work for as many columns/rows as possible.
Thank you so much!

SplitCells.jpg

 



1 REPLY 1
BenMoss
ACE Emeritus
ACE Emeritus

Hi @jcardoso,

 

This is quite a common issue that I see with our clients.

 

The attached workflow brings you to a solution and give's a common guide when working with such header types.

 

Ben

Labels