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