Use Multi Row to fill Blank Rows

[jagjit_singh]

Hi All,

I'm trying to use the multi-row tool to fill the blank rows for columns TR and NH as shown below. If the Current Ind is C then TR and NH should be blank and the values should move to the above row for the same Tenant Code. If Current Ind is F and there is a single row, then the values remain.

Desired Result

Thanks

Jag

[pcatterson · Accepted solution]

Something like this is how I'd probably approach the problem.

Summarize first and use the summarized groups for the multirow formula tool, then join the data back to the main stream.