Conversion Of Data In Column To One Cell

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

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

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.

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.

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

Quote:

---

Originally Posted by Excel Fox

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

---

Ok, its simplified version to see the core of it.Attachment 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.

Thanks for sharing macak