Concatenate data from cells by values from two columns

[YasserKhalil]

Hello everyone
It seems that the title of the thread is somewhat strange ..
I have sheets("Data") .. in Column B there are codes and for each code there are sub codes (numbers) and in column D there are strings that I need to concatenate ..
In Columns F:G there are other related data to the codes as each code has a name ..
This was the structure of Data sheet
*********
In Result sheet I would input Code in column F and the sub code in Column G (but the sub code could be sometimes concatenated like that 4|7 ..which mean 4 ,5, 6 and 7)
In column H I need the results as explained in the attachment ..

For example: in row 2 >> Code is 1 and sub code is 2|4 so I need to have 2 / 3 / 4 sub codes from Data sheet ...and put these between brackets ( )
and after 5 spaces put the name of the code and sub code between brackets < >
So the result would be like that

Please Login or Register  to view this content.

I need the solution to use arrays as original data is over 60,000 rows
Thanks advanced for help

[Mandeep Baluja]

Check this

Please Login or Register  to view this content.

'Made by :- Mandeep baluja
'https://www.facebook.com/groups/825221420889809/
'https://www.linkedin.com/in/mandeep-baluja-b777bb88
Add Reputation if it helped

[karedog]

Maybe :

Please Login or Register  to view this content.

[YasserKhalil]

Thanks a lot for these great and wonderful solutions
Really great and awesome
Thank you very much for helping me all the time

I will apply it to the original file and if there are any notes I would tell you soon
Best Regards

[karedog]

You are welcome, it's my pleasure.


Regards

[YasserKhalil]

@Mr. Karedog
I'm very sorry to disturb you again and again ..
As for this issue It is perfect but I need another addition ..
As for the results .. the numbers between < and > needed to be Arial font regardless the original font of the other characters
In fact the cell font is not Arial but I just need the parts between < > to be of Arial font ..
Thanks a lot for advanced help

[YasserKhalil]

Can it be done to have the results in the same cell with two different font type ???
I have posted the request on this link too
http://chandoo.org/forum/threads/for...nt-type.28885/

[bakerman2]

Don't have time for more but to give you an idea how it works.
On sheet Result select f.i. range H2 and run below code.

Please Login or Register  to view this content.

Select other cell and run code again.

[YasserKhalil]

Thanks a lot for this working method ..it is great
As for the large data .. will I deal with the 10,000 rows using loops ..? I think it will be disaster ..
Could font type be stored in an array or this is just a dream of mine?

[bakerman2]

Tried it with over 10,000 rows and it took about 1 sec. so I don't think that 's such a big disaster no ?

Please Login or Register  to view this content.

[YasserKhalil]

Thank you so much for this great help
Now it is solved
Best Regards

[bakerman2]

You're welcome and thanks for the rep