Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Need to use 2 headers and to unmerge cells

Hi Experts,

 

I have a data that has merged cells in excel with 2 rows of headers as shown below.

 

Please help me to get the output as shown below by unmerging cells in alteryx so that we can transpose the data 

1 REPLY 1
FrederikE
13 - Pulsar

Hey @ChallaSreenivasula

This WF relies on no other missing fields. If there are, seperate the headers first (Sample Tool) 

 

FrederikE_0-1684222861358.png

 

Also, please share the dummy file next time, then its much easier.

 

Labels