hoffchick92
New Member
- Joined
- Oct 26, 2013
- Messages
- 1
Hello,
So I have the results of a survey and the output given were
[TABLE="width: 1477"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Prof[/TD]
[TD]Course[/TD]
[TD]Description[/TD]
[TD]Prof2[/TD]
[TD]Course3[/TD]
[TD]Description[/TD]
[TD]Prof5[/TD]
[TD]Course6[/TD]
[TD]Description[/TD]
[TD]Prof8[/TD]
[TD]Course9[/TD]
[TD]Description[/TD]
[TD]Prof11[/TD]
[TD]Course12[/TD]
[TD]Description[/TD]
[TD]Prof14[/TD]
[TD]Course15[/TD]
[TD]Description[/TD]
[/TR]
</tbody>[/TABLE]
Each row has the responses. However I need it to look like
Name Prof Course Description
Prof 2 Course 3 Description 4
I have 30 rows with data recorded like this and need to generate 30 individual mini-tables with Prof, Course, Description kept to each name, but stacked for each name.
I am unsure how else to phrase it and I hope my illustration made sense.
Is there an easy way to do this? I've been going row by row and cutting and pasting in a different workbook.
Please help me and thank you very much. I am a senior in college and trying to create a database for my sorority and am not great with excel.
So I have the results of a survey and the output given were
[TABLE="width: 1477"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Prof[/TD]
[TD]Course[/TD]
[TD]Description[/TD]
[TD]Prof2[/TD]
[TD]Course3[/TD]
[TD]Description[/TD]
[TD]Prof5[/TD]
[TD]Course6[/TD]
[TD]Description[/TD]
[TD]Prof8[/TD]
[TD]Course9[/TD]
[TD]Description[/TD]
[TD]Prof11[/TD]
[TD]Course12[/TD]
[TD]Description[/TD]
[TD]Prof14[/TD]
[TD]Course15[/TD]
[TD]Description[/TD]
[/TR]
</tbody>[/TABLE]
Each row has the responses. However I need it to look like
Name Prof Course Description
Prof 2 Course 3 Description 4
I have 30 rows with data recorded like this and need to generate 30 individual mini-tables with Prof, Course, Description kept to each name, but stacked for each name.
I am unsure how else to phrase it and I hope my illustration made sense.
Is there an easy way to do this? I've been going row by row and cutting and pasting in a different workbook.
Please help me and thank you very much. I am a senior in college and trying to create a database for my sorority and am not great with excel.