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 RÉPONSE 1
FrederikE
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.

 

Étiquettes