Merge CloudWatch Queries Using the Table Merge Transformation

I’d love to be able to merge two results from AWS using the table transformations, but not sure it’s possible.
From the documentation (screenshot below), it shows two results from separate queries being merged.
This works (I assume) because the value columns have different names, Uptime and Errors.

However, with my queries using the CloudWatch datasource, both results come back with the value column as ‘value’ and so can’t be merged like the screenshot.
For example. My result from queries to s3 shows the two different storage types for bucket_1 on two different lines, I would like to get them on the same line with the storage types in different columns.
So far I have been unable to do this.
Anyone know if this can be done?