Is the Dimension1 the field name?
I believe the way to do this would require to build a sheet for each row.
Or it would require a change in the underlying data to add Dimension names as values for each row.
Yes, every Dimension you see is a different field name. So on the example above it would be
I was hoping for a workaround that didn't require me to restructure the data.