I need to shift my records up to get ride of a null row.
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.
@Brankl can you give an example?
I just need to shift the left three columns up so that they line up.
This can be achieved in multiple ways1- using multi row Formula2- using Transpose and Cross Tab3- Using Summarize toolI personally suggest using multi row formula toolyou can refer to the attached example you will definitely get the solutionif you struggle I will help with sol
@calvincarr29 use the MAX option in the summarize tool
one way of doing it find attached.
