Extracting Alt Enter data by Creating rows underneath using macros

Biogreg

New Member
Joined
Feb 24, 2014
Messages
2
Hello All, Ok so here is my data set


-- removed inline image ---


Top is what I have, bottom is what I need. Is there a Maccro way to do this? I tried using text to columns using the Alt H command to bring the data out, then indexing it down and that works for doing it 1 row at a time, but to preserve the data relationships I can't really do it for multiple columns As not all rows have multiple levels, and the ones that do do not have the same number of levels.

Any Help is appreciated.


Cheers.
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Biogreg

New Member
Joined
Feb 24, 2014
Messages
2
In 1 Row the data is
A
B
C
D
E
1
2
3
4
5
Happy
Go
Lucky
Fun
Times
Data Point 1Data Point 2
I need it in 5 rows
A1HappyData Point 1Data Point 2
B2GoData Point 1Data Point 2
C3LuckyData Point 1Data Point 2
D4FunData Point 1Data Point 2
E5TimesData Point 1Data Point 2

<tbody>
</tbody>

There are hundreds of rows like this out of thousands, and there are 6-7 columns of information like this that needs to be treated. Once again thanks for the help.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,931
Messages
5,447,380
Members
405,449
Latest member
Jfrusty

This Week's Hot Topics

Top