Margin Clusters

Hi! Unpivoted table:

I have a column with custumers ID, and another one that says if it's revenue, margin, or margin %. So for each account I have 3 rows, where in the 2nd column it says rev, mar, or mar_%, I'd like to create some clusters, like:

if the margin of the account is between 0 to 10%, or if the margin is from 10 to 20% or if the margin is more than 20%.

With those 3 ranges, I want to display the revenue for each of them. All the revenue where the margin is between 0 to 10%, all the rev where the margin is from 10 to 20%, and all the revenue where the margin is bigger than 20%...

I've been thinking on how to do it, but I cant come up with any idea...