Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
We’re experiencing technical issues with our vendor that are affecting license activations for Designer Desktop. We don’t yet have an estimated resolution time. We apologize for the inconvenience and will share updates as we have them.
Start Free Trial

Alteryx Designer Desktop Discussions

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

How to add a blank row after every month without losing any data

Polite123
8 - Asteroid

Hi All,

 

Need some quick help in my data set.I want to add a blank row after every month without losing any data

 

Input data:

MonthsABC
Jan1200
Jan1200
Jan1200
Feb1300
Feb1600
Feb4500
Mar1700
Mar6655500
Mar000
Apr2500
Apr36900
Apr21200
May1200
May1200
May2500
Jun2400
Jun3600
Jun3600

 

Output data:

 

MonthsABC
Jan1200
Jan1200
Jan1200
    
Feb1300
Feb1600
Feb4500
    
Mar1700
Mar6655500
Mar000
    
Apr2500
Apr36900
Apr21200
    
May1200
May1200
May2500
    
Jun2400
Jun3600
Jun3600

 

 

Any help would be appreciated.Thanks in advance:)

2 REPLIES 2
grazitti_sapna
17 - Castor

Hi @Polite123 , try this if it works for you.

grazitti_sapna_0-1599895929399.png

If this is what you are looking for please mark this post as a solution and give it a like.

Thanks.

 

 

Sapna Gupta
Polite123
8 - Asteroid

That's really great...thanks:)

Labels
Top Solution Authors