Hello,
I wish to transpose my data (as shown in "Current State") into both the Desired State options. I was able to do it using a combination of filter, unique, cross tab & select tool - but I believe it not an efficient way to do it.
Solved! Go to Solution.
I think you will just need a transpose, filter and cross tab to achieve your two desired states (attached).
With more than one record you'd have to introduce a field which you can use to group by (also attached)
This was an amazingly simple solution (I wonder why I couldn't think this through). This worked perfectly fine for me. Thanks :)