Excel Macro to re-format data

[moorej]

I have data in multiple columns that repeats except for one date reference. The X0 column starts with a date and the date updates with the next data reference. I need to move the All data like the reference number in column A down to the next row until all have been moved. Column A is the place holder for the data. The data may repeat many more times than the example. In the example it only repeats 4 times. There are also many more columns of data, but in the example there are only 4.

The macro should run until there is no more data to move. The result should look like the lower example. I'm not sure how I can do this. I can modify a macro created with this example but have no clue as to how to begin to write it.

Any help would be welcome. Thanks in advance.


Data comes in like this

A B C D E F G H I J K L M N O P
NUMA NUMB X0 X0H
101064 670 3/1/2014 0.50 101064 670 4/1/2014 0.50 101064 670 5/1/2014 0.50 101064 670 6/1/2014 0.50
102065 671 3/1/2014 0.50 102065 671 4/1/2014 0.50 102065 671 5/1/2014 0.50 102065 671 6/1/2014 0.50
103067 673 3/1/2014 0.50 103067 673 4/1/2014 0.50 103067 673 5/1/2014 0.50 103067 673 6/1/2014 0.50

Would like to have it look like this

A B C D
NUMA NUMB X0 X0H
101064 670 3/1/2014 0.50
101064 670 4/1/2014 0.50
101064 670 5/1/2014 0.50
101064 670 6/1/2014 0.50
102065 671 3/1/2014 0.50
102065 671 4/1/2014 0.50
102065 671 5/1/2014 0.50
102065 671 6/1/2014 0.50
103067 673 3/1/2014 0.50
103067 673 4/1/2014 0.50
103067 673 5/1/2014 0.50
103067 673 6/1/2014 0.50

 

[moorej]

Bump

 

[hiker95]

moorej,

I will try to upload a sample workbook with sample data.

Bump

What happened to the workbook?

 

[moorej]

I guess our firewall will not allow a connection. I wasn't able to upload.

 

[hiker95]

moorej,

I guess our firewall will not allow a connection. I wasn't able to upload.

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 your data, you can download and install one of the following two programs:
Excel Jeanie
MrExcel HTML Maker

Or, when using Internet Explorer, just put borders around your data in Excel and copy those cells into your post.
See reply #2 the BLUE text in the following link:
http://www.mrexcel.com/forum/about-board/444901-how-create-table-like-aladin.html#post2198045

 

[moorej]

I was able to upload a sample file to Box Net from home. I think I did it correctly. I added the macro I modified and it seems to work.

Here is the link:

https://app.box.com/s/5a86mcok3l1nb82kfqot

 

[hiker95]

moorej,

Thanks for the workbook.

Your two data sets are completely different.

Your new workbook, worksheet Sheet1, contains 234 columns?????

Can we have another workbook, containing the above mentioned Sheet1, and, on another worksheet (manually formatted by you) the results you are looking for?

 

[moorej]

Hi hiker95,

The workbook I uploaded is sample data in the actual format of my raw data but fewer rows. There are 234 columns and currently 4889 rows (but the row count can grow). I included a modified macro from an above post that seems to work on the data set. The first 18 columns repeat 13 times with only a difference in column 17 in each.

Thanks for looking.

 

[hiker95]

moorej,

So that I can get it right the first time, I will need to see what the results should look like.

Can we have another workbook, containing the above mentioned Sheet1, and, on another worksheet (manually formatted by you) the results you are looking for?