Shift records up

[calvincarr29]

I need to shift my records up to get ride of a null row.

 

[Brankl]

You can use the summarize tool to concatenate rows. The nulls won't have a value, so combining these two rows gets you the result you're looking for.

[calvincarr29]

@Brankl can you give an example?

[calvincarr29]

I just need to shift the left three columns up so that they line up.

[Raj]

This can be achieved in multiple ways
1- using multi row Formula
2- using Transpose and Cross Tab
3- Using Summarize tool

I personally suggest using multi row formula tool
you can refer to the attached example you will definitely get the solution
if you struggle I will help with sol

[binuacs]

@calvincarr29 use the MAX option in the summarize tool

[Raj]

one way of doing it find attached.