In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
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