Conversion Of Data In Column To One Cell

[macak]

Hi, I would like to convert on xls, generate from SAP to some more useful form. But, I failed on converting vertical cells into one cell. I was searching on internet whole day, but without any success. I would prefer Formulas solution. I also find similar problem here on forum solved by formulas, but I was not able to use it for my scenario.
There is one more thing that the array which I want to merge, is different each time.

Description: This is list of electrical components generated from SAP its called Bill Of Material. Some other description is in attached document. Some columns are hidden, they are not relevant for conversion.

Thanks for help,
Vojta

[Excel Fox]

macak, can be done, but I would recommend VBA for this rather than formula.

[macak]

Ok, I would prefer Formulas because Im totally new to VBA, well in some advanced work with Excel too.
What I created so far with formulas is actually "retyped" cycle, so I guess the solution with VBA could be easy if created for only this doc.

[macak]

So, I managed to made it finally. It was not actually so hard at the end I just needed to learn about Indiricet formula. If someone would be interested I can attach XLS.

[Excel Fox]

Yes, would be great if you could attach the solution here

[macak]

Yes, would be great if you could attach the solution here

Ok, its simplified version to see the core of it.1153
So, I managed to covert columns to one cell, but with help of some things, like I know number of there vert. cells when Im at ProductNumber, its already generated. Therefore I do not have some function which would do that, and I guess it could be complicated. Hopefully it could be useful at least to someone.

[Excel Fox]

Thanks for sharing macak