You're saying the query output needs to be horizontal rather than vertical? For tank Number you have 5 empty columns/fields but only show 3 tanks - or is that just because the query pic only shows 3? I think you're indicating that your query needs to be a crosstab query so that vertical is transposed to horizontal. If that is the case, be aware that such a query has to be set up so that it always returns the same fields, otherwise the report will error.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.