This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Combine Field1 with value of Field 2 ~ 5 and Sum of Field 6 ~ 9 HELP!!!
Solved! Go to 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!
Thank you very much! I have another problem like this but much more data is included. I will try this 🙂