Combine Field1 with value of Field 2 ~ 5 and Sum of Field 6 ~ 9 HELP!!!

[jayryan612]

Combine Field1 with value of Field 2 ~ 5 and Sum of Field 6 ~ 9 HELP!!!

[lmorrell · Accepted solution]

Hi @jayryan612,

Solution is attached. 

If each of your columns contains only one value per field1, and all remaining values are null - then taking the MAX of fields 2,3,4 & 5 will return you the desired values along a single row. 

However, if you have messier data with multiple values - then @Thableaus comment on this solution using the tile tool has helped me to remove nulls from complex data sources. 

Hope this helps!

[jayryan612]

Thank you very much! I have another problem like this but much more data is included. I will try this