I
ILoveMyCorgi
I have an Excel spreadsheet with three columns: ColA has a student number,
ColB has a comment, and ColC has an amount. I have many rows of different
comments and amounts for the same student number followed by rows with new
student numbers and so on. I need to move all of columns B and columns C to
the same row of the first line for the student number and move on to the next
student number. What I am trying to do is have all the data for one student
on one row so that I can merge the data with a Word document.
For instance,
1495 writing in book $10.00
1495 football trans $ 5.00
3456 Water damage $15.00
3456 Lost Textbook $35.00
Witn an outcome of:
1495 writing in book $10.00 football trans $5.00
3456 Water damage $15.00 Lost Textbook $35.00
I hope someone can help me with this. Thak you.
ColB has a comment, and ColC has an amount. I have many rows of different
comments and amounts for the same student number followed by rows with new
student numbers and so on. I need to move all of columns B and columns C to
the same row of the first line for the student number and move on to the next
student number. What I am trying to do is have all the data for one student
on one row so that I can merge the data with a Word document.
For instance,
1495 writing in book $10.00
1495 football trans $ 5.00
3456 Water damage $15.00
3456 Lost Textbook $35.00
Witn an outcome of:
1495 writing in book $10.00 football trans $5.00
3456 Water damage $15.00 Lost Textbook $35.00
I hope someone can help me with this. Thak you.