Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAMy version of the solution. As others have noted, the 2015 Team Rank is no longer included in the original files.
Hello @ponraj ,
Can you tell us why you added two Dynamic Rename tools? I'm trying to understand how it is being used based on your spoiler pic. Sorry, my laptop is being repaired and I don't have access to open the workflow right now.
Solution attached. One of the players was listed twice in the desired output, despite there only being 252 in the fantasy list. There was also no data on 2015 rank, excluding in the desired output.
Hi @dmodest , First one is to make first row values as column header. I used same tool second time to rename some column header using formula.