Shifting and combining columns using VBA

Hi, I have VERY LITTLE knowledge in VBA. However, I need to complete this task, and it must be done in VBA.

Please download the attached data. What I am trying to accomplish is hard to explain if you do not have the data in front of you.
DATA: Data.xlsx

What I am trying to do is this:

I want to align all the "Amount and Kind of Material Used" cells under one column. In this small data, the LAST column with "Amount and Kind of Material Used" is column R. So ideally, I want all the other "Amount and kind of material used" to shift over to either column r, or the next column, as well. Keep in mind that this should move all other cells after "Amount and Kind of Material Used" as well.

Once this is completed, I want to COMBINE ALL CELLS after the "Amount and Kind of Material Used" column into one cell with an underscore in between.

can someone PLEASE help me with this?

or help me START the code. I'm on Google reading VBA for dummies and it really isn't helping.

Thanks.

Originally Posted by patel45

can you attach also desired result

Results.xlsx

here is the desired result

Also www.ozgrid.com/forum/showthread.php?t=181732 with replies.