Messages

Forum Index : Technology : Messages
Author: [Technology] Topic: Help with MS EXCEL
fish1982 send a private message View Space | Blog | Friends | Playbook |
fish1982
Participation Meter
Prospect
Joined: Nov 2008
Posts: 174
Location: United States
#1
Posted: 8/23/2012 10:20:41 PM

Using excel does anybody know how to make a new row after 3 column cells of data?

Here is what I have got: First I had a string of data that was in one big column, but I wanted it to run horizontal instead of vertical so I got that by copying, selecting paste special then checking box "transpose". That was step 1, now I need to get to the second step which is figure out how to make every three columns break up and go to the next row since that starts a new record. For example, let us say that I have 10 students in a class and I have there first name in one cell, last name in the second cell and their age in the 3rd cell. The problem is that they are all in one long row so if I have 10 students, it is all in row 1 and goes from column A to all the way to column DD or whatever and I need it to start a new row after going to column C so instead of the table running from row 1 to column DD I need it to run from row 1-10 and column A-C. got it? There are a few things to keep in mind:

1. I am currently using Excel 2003, but I am sure 2007 or 2010 is much the same
2. I do NOT need the data WITHIN the cell separated. Each piece of data is already separated into each cell
3. There is no unique character like a colon or comma at the end of each cell so I can't use that as some sort of marker to tell EXCEL when to break into a new row
4. I basically need to tell it to go to a new row after so many cells or columns, how do I do that???
5. I have tried the DATA-TEXT to Columns feature I don't think that is the answer
quote
allbees send a private message View Space | Blog | Friends | Playbook | My Sportsbook: Pinnacle Sports |
allbees
Participation Meter
Covers Linesmen
Joined: Dec 2004
Posts: 15780
Location: Heard and
              McDonald Islands
#2
Posted: 8/28/2012 10:10:15 AM
Don't think you are going to get that done without writing a macro to do it.
quote
mr_bollox send a private message View Space | Blog | Friends | Playbook |
mr_bollox
Participation Meter
All-Star
Joined: Oct 2009
Posts: 10193
Location:
#3
Posted: 9/6/2012 8:50:52 PM
i need to brush up on my excel, is there a good online program/course i can use/buy someone can recommend
quote
KktdocT
RSI Wagerline RSI Rating
send a private message View Space | Blog | Friends | Playbook |
KktdocT
Participation Meter
Legend
Joined: Jan 2006
Posts: 63992
Location: United Kingdom
#4
Posted: 9/7/2012 11:13:20 AM
"Google" is your friend.
quote
AustinHoopDream send a private message View Space | Friends | Playbook |
AustinHoopDream
Participation Meter
Banned
Joined: Feb 2006
Posts: 8408
Location: Illinois
#5
Posted: 10/25/2012 5:59:04 PM
flux capacitor.

quote
theredone6
RSI Wagerline RSI Rating
send a private message View Space | Blog | Friends | Playbook |
theredone6
Participation Meter
Prospect
Joined: Sep 2009
Posts: 207
Location:
#6
Posted: 12/8/2012 3:54:39 AM

http://www.youtube.com/watch?v=vz0jpWSG5Gc


ohh man hated excel but  had to learn it. i found using youtube to find specific things useful should give it a try. 

quote
Forum Index : Technology : Messages
You have entered the forum as a GUEST. 
You must login/register to post or reply.