Complex Concetenate of cells using vba

Hello.

Im not really sure how to explain this or if it even could be done, but iv searched the forums and web without any luck so here goes.
To try to make it easier im posting an example WB of the result i want using the Concetenate formula.

The excel wb is a generated file from a database of information, It is always named "Rapport.xls" when data is exported. this one has a (1) becouse its same one exported twice.

What i would like to do is Concetenate all cells cointaining for example "Golv" in the header. as i have done in the workbook, then its just copy row and special paste values. in column to the left of the column with red marked header.

Problem is that some cells in columns E to F has more than one line inside, so the quite allready long concetenate formula must be extended. to make it work for cells that have 2 lines so the information belonging to right line inside cells gets the right information. Now this is done quite easy, and with just expand rest of cells gets same formula. the more complex part comes with column AB for the "Övrigt" cells. Some have 1 line some have 2-3 and some have 8-11 lines in the cells.
So i must edit formula for the longer ones and make it fit so it works for the 8-11 line cells.

Click further down when u find a cell containing much info to se what i am talking about.

Now could this be done by say maybe a smarter way using formulas or can there be some VBA code that handles this?

The concetenate formula i must give credit to you guys for providing it to me on this forum. but i need something easier and better way, if it is possible.

I know i may be asking alot, but i could really use some help here.

By different line i mean that in the cells information is separated by (Alt + Enter) line break. and data from example Cell E2 line 1 must be matched wit data from cell F2-H2 line 1, and line 2 in cell E2 with data from line 2 in cell F2-H2 and so on.

I hope i make at least some sense to someone who could help me. Otherwise just let me know and i will try to explain more. hoppfully the example wb provides better example. I have done all the modification of formula in all but the lower part of AB column. Data in the columns with red marked headers is how the result should look like.

Thanks alot in advance for all the help you guys choose to provide!

Cheers

Upploaded file with *.xlsx extension instead. should not be getting the pop upp warning when you try to open it now.

Thanks for the heads up.

Cheers

Ofcourse, just looking at the formula where it is a bit longer gives one a headache, so understandable.

What is does is pretty much this,

It maps information from 4 different colums into one for every row in the sheet. But some cells have more than one line of information in it, so it maps the information by line. hope that makes sense. So if in fist cell the data is devided in say 3 lines. it need to get line 1 and then line 1 from the rest of the colums and then line 2 and so on.

Lines in the cells are divided by a (Alt + Enter) limiter. if i use just regular Concetenate, the function takes all the lines in first column, then adds the next column at the end and so on, making it hard to se what information belongs to what material for example.

Does that explain it somehow?, and last but not least. the number of lines in cells vary. so cells in one row might only have 1 line, but row 2 has 4 line and so on.

If you look in column D2, thats how the result should look like in text form not in formula code. and it maps info from cell E2, F2, G2, H2.

Hope that explains something.

Thanks for your time and patiance!!

Cheers