Excell Macros - Row Splitting.

[mkay110]

Dear all, I am in need of some help in creating a macro to get excel to do the following instruction:
Split a row with different bullet points (a), b), c) ) in a single cell, to 3 different cells. Thus, there would be a need to insert new cells too.

E.G. Current format:

A B C D E
1 Name Age Problem Helped by Date
2 MIKE 99 a)Excel Help a)xxxxx a)1/1/1
b)other b)someone b)2/2/2
c)other 2 c) someone 2 c)3/3/3
3 Person 2 23 a)1 a)1 a)1/1/1
b)2 b)2 b)2/2/2
c)3 c)3 c)3/3/3

What I would like is the following:
Desired format:
A B C D E
1 Name Age Problem Helped by
2 MIKE 99 a)Excel Help a)xxxxx a)1/1/1
3 MIKE 99 b)other b)someone b)2/2/2
4 MIKE 99 c)other 2 c) someone 2 c) 3/3/3
5 Person 2 23 a)1 a)1 a)1/1/1
6 Person 2 23 b)2 b)2 b)2/2/2
7 Person 2 23 c)3 c)3 c)3/3/3

The reason for this request is i have a lot of spreadsheets with the current format, and would like to change them to the new format, for emailing reasons (data protection - problems are confidential and cannot be all sent). I would highly appreciate if you could advise me on how to create this.

Thank you

 

[Crystalyzer]

Your data structure is really difficult to understand. Do you mean it looks like this below? Also, are there ALWAYS three bullet points and are they ALWAYS a) b) c)?

[TABLE="class: grid, width: 200"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Age[/TD]
[TD]Probelm\Help\Date[/TD]
[/TR]
[TR]
[TD]Mike[/TD]
[TD]99[/TD]
[TD]a) Excel Help Person 1 1/1/15
b) other Person 2 2/2/15
c) other 2 Person 3 3/3/15[/TD]
[/TR]
[TR]
[TD]Person 2[/TD]
[TD]23[/TD]
[TD]a) 1 1 1/1/15
b) other Person 2 2/2/15
c) other 2 Person 3 3/3/15[/TD]
[/TR]
</tbody>[/TABLE]

 

[hiker95]

mkay110,

Welcome to the MrExcel forum.

1. What version of Excel, and, Windows are you using?

2. Are you using a PC or a Mac?


We can not tell where your raw data is located, sheet name, cells, cell formatting, rows, columns, and, we can not tell where the results should be, sheet name, cells, cell formatting, rows, columns.


To start off, and, so that we can get it right on the first try:

Can you post a screenshot of the actual raw data worksheet?

And, can you post a screenshot of the worksheet results (manually formatted by you) that you are looking for?

To post a small screen shot (NOT a graphic, or, picture, or, PNG file, or, flat text) try the following:

Click on the below link to see How to display your sheet, and, how to install, download, and, use the MrExcel HTML Maker:
http://www.mrexcel.com/forum/board-announcements/515787-forum-posting-guidelines.html

To test the above:
Test Here

Or, you can post your workbook/worksheets to the following free site, and provide us with a link to your workbook:

Sensitive data changed

https://dropbox.com

 

[mkay110]

Thank you for your response.

I am using MS Excel 2010 on windows 7.

[/IMG]

My desired format is the following: please not only Row J,K and L need splitting. The rest of the rows need copying and pasting into the new rows.

[/IMG]

Please note, The amount of points needing splitting vary.

I hope this is more clear.

Thank you all very much for your help.

 

[mkay110]

I have posted a more clear explanation above; the amount of bullet points do vary,Thank you for your response.

 

[hiker95]

mkay110,

You are posting IMG pictures. This means that if this was a problem where one needed to use your data, anyone trying to help you would have to enter the data manually. That makes no sense and I doubt that you would get any answer.


Can you post a screenshot of the actual raw data worksheet?

And, can you post a screenshot of the worksheet results (manually formatted by you) that you are looking for?

To post a small screen shot (NOT a graphic, or, picture, or, PNG/IMG file, or, flat text) try the following:

Click on the below link to see How to display your sheet, and, how to install, download, and, use the MrExcel HTML Maker:
http://www.mrexcel.com/forum/board-announcements/515787-forum-posting-guidelines.html

To test the above:
Test Here

Or, you can post your workbook/worksheets to the following free site, and provide us with a link to your workbook:

Sensitive data changed

https://dropbox.com