PDA

View Full Version : [SOLVED] Code needed to organize data



eb818
05-21-2015, 05:07 PM
Hello,

Thank you for reading this. I am looking for a way to organize my data in excel via coding. What I am looking to do is shown below:

The information I have is organized like this:

Zach Britton The Continuum
#53, P Closure
The Continuum
Alive


Ryan Flaherty Dropkick Murphys
#3, OF/3B/2B Wild Rover



I am trying to make my data look like this:
Player Position Artist Song
Zach Britton #53, P The Continuum Closure
Zach Britton #53, P The Continuum Alive
Ryan Flaherty #3, OF/3B/2B Dropkick Murphys Wild Rover


The hardest part about this set of data is that there are some players who have more than one song. Some have up to five. With that, the players who have more than one song have blank cells. I have attached a zip file with a sample of my data. The first sheet is my raw data and the second sheet has what I am looking to do. I hope you can help! Thank you in advance for your time!