eb818
06-07-2014, 05:03 PM
Hello!
Thank you for taking the time to read this. I am not the biggest technology person but the company I work for is trying to find a way to update its database of clients. I'm sure you'll probably be able to tell that I am not the best at this stuff by the way I describe my issue.
I am trying to organize a bunch of data in Excel from a website.When I copy and paste, it comes out like this:
Name: John Smith, PGA
City/State: Scottsdale, AZ
Classification: A-1
Club: Desert Mountain Golf Club
Section: Southwest Section
Phone: (867) 555-5555
E-Mail: jjjjjjjjj
Name: Dale R Johnson, PGA
City/State: Scottsdale, AZ
Classification: A-14
Club: Desert Mountain/Renegade
Section: Southwest Section
Phone: (444) 555-6666
E-Mail: ddddd
Name: Jack A Adams
City/State: Maricopa, AZ
Classification: B-8
Club: Southern Dunes Golf Club
Section: Southwest Section
Phone: (777) 888-9999
E-Mail: sssss
The data pastes just fine and actually is helpful that it splits the categories and actual information up by cell. In other words, the Email is in a separate cell from the actual email itself.
What I am trying to do is make it so that way the information appears like this:
Name: City/State Classification
John Smith Scottsdale, AZ A-1
Dale R Johnson Scottsdale, AZ A-14
Jack A Adams Maricopa, AZ B-8
I think you get the idea. Everything would be in their own cell. I don't know if this is something that would even be possible through coding, but if it is, would anyone be willing to show me how you would do it? I have tried to teach myself coding online, but I just don't seem to get it. I realize that nobody on this forum has to, nor am I expecting anyone to, but it would be a huge help if you could and I would greatly appreciate it!
Thank you for taking the time to read this. I am not the biggest technology person but the company I work for is trying to find a way to update its database of clients. I'm sure you'll probably be able to tell that I am not the best at this stuff by the way I describe my issue.
I am trying to organize a bunch of data in Excel from a website.When I copy and paste, it comes out like this:
Name: John Smith, PGA
City/State: Scottsdale, AZ
Classification: A-1
Club: Desert Mountain Golf Club
Section: Southwest Section
Phone: (867) 555-5555
E-Mail: jjjjjjjjj
Name: Dale R Johnson, PGA
City/State: Scottsdale, AZ
Classification: A-14
Club: Desert Mountain/Renegade
Section: Southwest Section
Phone: (444) 555-6666
E-Mail: ddddd
Name: Jack A Adams
City/State: Maricopa, AZ
Classification: B-8
Club: Southern Dunes Golf Club
Section: Southwest Section
Phone: (777) 888-9999
E-Mail: sssss
The data pastes just fine and actually is helpful that it splits the categories and actual information up by cell. In other words, the Email is in a separate cell from the actual email itself.
What I am trying to do is make it so that way the information appears like this:
Name: City/State Classification
John Smith Scottsdale, AZ A-1
Dale R Johnson Scottsdale, AZ A-14
Jack A Adams Maricopa, AZ B-8
I think you get the idea. Everything would be in their own cell. I don't know if this is something that would even be possible through coding, but if it is, would anyone be willing to show me how you would do it? I have tried to teach myself coding online, but I just don't seem to get it. I realize that nobody on this forum has to, nor am I expecting anyone to, but it would be a huge help if you could and I would greatly appreciate it!