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:)
User | Count |
---|---|
109 | |
89 | |
77 | |
54 | |
40 |