Reformatting Data Pulled Through API

Hi. I am pulling list data from two separate APIs that give results in different formats. The first format works great, and allows me to plot the data in charts with ease. The seconds format however, does not work at all. Is there a way to transform the data in the second format to match the first, without storing the data in a database?

Format 1:

Format 2:

You could do it with a custom built plugin :wink: