M
Moanster
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
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