Union data that disregarded the null row

[arjundelara]

Hi,

The first image is the main output format.

2nd image is the monthly captured data

this 3rd image is my output when I union the 1st and 2nd image but the expected result is based on the month it will join with out the null row.

Hope there's someone can help me to this.

Thank you!

[Emil_Kos]

Hi @arjundelara,

If I understand you correctly you want to populate missing Jul data. 

You need to use the join function. Join the two data sets by record position and use the formula tool to fill the missing data. 

I hope this helps. 

[ArtApa]

Hi @arjundelara - Here is how: