Inserting Multiple Rows in a single Excel Cell?

Question

How do I insert Multiple Rows in a single Excel Cell?  Not insert multiple rows in a spreadsheet. I specifically need to add rows into several preordained cells. 

Thank you

Answer 1

I am guessing but it appears that you used tables in Word to create your example and you want a similar thing in Excel.

From your example it appears that if you need 6 rows beginning from column 2 then in column 1 merge 6 cells for the row titles (ie. Project 1, Project 2, Project 3 etc). That will effectively provide you with one extra high cell for the row titles in the first column and 6 standard height rows for each of the columns to the right. 

As per the following screen shot where I have also applied Left justify and Top justify to the merged cells in column 1. I have not applied any borders but you should be able to do that as required.

Answer 2

If the following screen shot is what you mean then at the end of each row use Alt and Enter to insert a line feed within the cell

It will normally default to "Wrap text" but if "Wrap text" is turned off then it will display as one line. "Wrap text" is in the Alignment block on the Home ribbon

Answer 3

I am not attempting to wrap text.  See the idea below. I want each student's name to be represented in its own Row beginning with Rank Pref 1.  So the Project title I a block and off of that block I want 6 rows beginning at Column 2

****	****	Rank Pref 1	Rank Pref 2	Rank Pref 3
Project 1 - Accelerate Diagnostics - Market Expansion		Student Name 1<br><br>Student Name 2<br><br>Student Name 8	Student<br> Name 5<br><br>Student<br> Name 3<br><br>Student<br> Name 9
Project 2 - Siemens - Analyzer Market for Cyber security		Student Name 3<br><br>Student Name 6 <br><br>Student Name 5
Project 3 - Siemens - Analyze Market For Cybersecurity Services

Thank you

Answer 4

I am not attempting to wrap text.  See the idea below. I want each student's name to be represented in its own Row beginning with Rank Pref 1.  So the Project title I a block and off of that block I want 6 rows beginning at Column 2

		Rank Pref 1	Rank Pref 2	Rank Pref 3
Project 1 - Accelerate Diagnostics - Market Expansion		Student Name 1<br><br>Student Name 2<br><br>Student Name 8	Student<br> Name 5<br><br>Student<br> Name 3<br><br>Student<br> Name 9
Project 2 - Siemens - Analyzer Market for Cyber security		Student Name 3<br><br>Student Name 6 <br><br>Student Name 5
Project 3 - Siemens - Analyze Market For Cybersecurity Services

Thank you 

OK 

The table above is the result you want

But 

How is the original data look like?

Show some pictures of your original data and other picture in the way you want the results

Answer 5

Hi

Could you show us some sample pictures of your data and the expected results?

To better understand your scenario.