I need to join two columns from the same list in a data view web part.
Player1 Player2 Points Jack Ben 5 Jack Tom 3 Tom 2
So the result from the data view web part would be:
Player Points Jack 5 Jack 3 Ben 5 Tom 3 Tom 2
Is this possible? I was able to easily get Player1 and Points to display in the web part, but I cannot figure out how to add the Player2 column data to the end of the existing list.
Any help would be greatly appreciated!
I want to join the two Player columns and then group by Player. Jack in row one and two of the Sample List is the same person (Tom in row two and three is also the same person).
If I was able to get the Player1 and Player2 columns joined into one column, I would then like to group the results by Player (and then I have the DVWP summing the points for each player).