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:
| Months | A | B | C | 
| Jan | 12 | 0 | 0 | 
| Jan | 12 | 0 | 0 | 
| Jan | 12 | 0 | 0 | 
| Feb | 13 | 0 | 0 | 
| Feb | 16 | 0 | 0 | 
| Feb | 45 | 0 | 0 | 
| Mar | 17 | 0 | 0 | 
| Mar | 66555 | 0 | 0 | 
| Mar | 0 | 0 | 0 | 
| Apr | 25 | 0 | 0 | 
| Apr | 369 | 0 | 0 | 
| Apr | 212 | 0 | 0 | 
| May | 12 | 0 | 0 | 
| May | 12 | 0 | 0 | 
| May | 25 | 0 | 0 | 
| Jun | 24 | 0 | 0 | 
| Jun | 36 | 0 | 0 | 
| Jun | 36 | 0 | 0 | 
Output data:
| Months | A | B | C | 
| Jan | 12 | 0 | 0 | 
| Jan | 12 | 0 | 0 | 
| Jan | 12 | 0 | 0 | 
| Feb | 13 | 0 | 0 | 
| Feb | 16 | 0 | 0 | 
| Feb | 45 | 0 | 0 | 
| Mar | 17 | 0 | 0 | 
| Mar | 66555 | 0 | 0 | 
| Mar | 0 | 0 | 0 | 
| Apr | 25 | 0 | 0 | 
| Apr | 369 | 0 | 0 | 
| Apr | 212 | 0 | 0 | 
| May | 12 | 0 | 0 | 
| May | 12 | 0 | 0 | 
| May | 25 | 0 | 0 | 
| Jun | 24 | 0 | 0 | 
| Jun | 36 | 0 | 0 | 
| Jun | 36 | 0 | 0 | 
Any help would be appreciated.Thanks in advance:)
Solved! Go to Solution.
Hi @Polite123 , try this if it works for you.
If this is what you are looking for please mark this post as a solution and give it a like.
Thanks.
That's really great...thanks:)
 
					
				
				
			
		
