I have data that looks like this
Parameter Event_1 Event_2 Event_3
A 0.1 0.2 0.1
B 0.3 0.6 0.1
C 0.5 0.7 0.1
And, I want to make it look like this:
Location Paramater Result
Event_1 A 0.1
Event_1 B 0.2
Event_1 C 0.1
Event_2 A 0.3
Event_2 B 0.6
Event_2 C 0.1
Event_3 A 0.3
Event_3 B 0.6
Event_3 C 0.1
The catch is that I have 365 parameters and 768 Events
I've tried a number of different things, including pivots, vba, lookups, index and match but they all seem to rail or are too cumbersome. There has to be an easy way.
Any suggestions are appreciated.
Bookmarks