Hi all,
I know I've gotten this answer before by searching the forum, but I cannot
find it now. I have an array of values

userid value1 value2 value3
u001 58 64 99
u002 104 13 56
u003 23 15 86

and I want to create a list showing each distinct value for the user, like so:

u001 58
u001 64
u001 99
u002 104
u002 13
u002 56
u003 23
u003 15
u003 86

As I recall, this could be done by a pvot table, doing something strange
with the pivot. Does anyone have any suggestions?

Thanks