how to split multi line cell contents of two column into separated rows in excel using VBA

Manosub

New Member
Joined
Nov 19, 2018
Messages
2
Hi All,

I'm Currently facing issue in splitting my Multi-Line cell contents into separate Rows in excel VBA. I tried searching in Internet the solution which i could find is for only one column Multi-line cell, i have two column multi line cell and i want to split the same.

For more clarity I have given the screen shot of my Excel data.
Original Data:


Req #QuestionAnswers
AR-0031.Do we expect any other user at school to have access to this view?
2.Is there an expectation that school users can send reminders for cases which are more urgent?
AR-0021.Do we expect any other user at school to have access to this view?
2.Is there an expectation that school users can send reminders for cases which are more urgent?
1.Programme coordinator would be raising the request I believe. No, reminders will be system driven to staff
AR-0011. What all cases are auto approved?
2. Is there an expectation that auto approved cases can be reviewed and decisions can be changed?
3. How would we differentiate emergency cases and normal advice request?
4. Is evidence upload expected for all cases or this will vary by cases?
1. BR for this module not fully defined yet but imagine there might be some auto approvals.
2. Yes, same kind of functionality as A and I when it can be manually reviewed and case might be amended but the timescales around these are going to be much tighter
3. We will have to have categories
4. It will vary

<tbody>
</tbody>









































Needed Output:

ReqQuestionAnswer
2.Is there an expectation that school users can send reminders for cases which are more urgent?
AR-0021.Do we expect any other user at school to have access to this view? 1.Programme coordinator would be raising the request I believe. No, reminders will be system driven to staff
2.Is there an expectation that school users can send reminders for cases which are more urgent?
AR-0031. What all cases are auto approved?1. BR for this module not fully defined yet but imagine there might be some auto approvals.
2. Is there an expectation that auto approved cases can be reviewed and decisions can be changed?2. Yes, same kind of functionality as A and I when it can be manually reviewed and case might be amended but the timescales around these are going to be much tighter
3. How would we differentiate emergency cases and normal advice request?3. We will have to have categories
4. Is evidence upload expected for all cases or this will vary by cases?4. It will vary

<tbody>
</tbody>




































If possible can we Merge the Req # in the first column for the question & Answers as one cell?

Please help me out if some one have solution for this as i have to do this manually for more than 100 to 200 line item daily which is taking more time.

Regards,
Manoj
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Manosub

New Member
Joined
Nov 19, 2018
Messages
2
sorry while pasting the needed table got messed. I want to split the cell values of question and answer in each row along with the Req#. so that each question in column B will have its Answers in Column C
 

Watch MrExcel Video

Forum statistics

Threads
1,109,275
Messages
5,527,728
Members
409,785
Latest member
AdamPriest

This Week's Hot Topics

Top