Posted:
#1
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
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
0
Hot Forum Topics
