Condensing Row Data in Fewer Tools

Question

Hi All,

I'm attempting to get the info from these three columns condensed into one row - issue is the values that I need are in 3 separate rows. I need the value from the second cell under total accrual, first under nonaccrual, and third under principal all to be on the same row, and only that row is needed. I believe I can figure this out but in many more tools than necessary, so was hoping you guys may be able to help condense the process. Thanks!

Ben_H · Accepted Answer

Hi @BSmithdubz,

Is the table always going to be formatted that exact way?

If so it looks like the value you want is always going to be the highest one in any particular column (this is quite a big assumption on my part).

If that was the case you could just use a summarise tool, and get the MAX of each column like this -

There are various other ways of doing it but this is the simplest I can think of assuming that value you need in each column will always be the max

Regards,

Ben