Lookup Value then Conditionally Merge data (Excel 2007)

Lookup Value then Conditionally Merge data (Excel 2007)

Search (lookup) data of Column B in Column D, if matched data is found, merge all data of Column E for matched one into Column C and meet following additional requirement:
1.if only one matched data is found, data could be directly moved to Column C.
2.if more than one matched data is found(More than 2 card# to be merged):
if Duplicated card# is found, please keep only one
please sort the number from small to large
if card# is NOT blank, please insert one line break after each card# except the last Card#


note:

• Number of ROW in D is up to 6000
• Number of ROW in B is less than 1500.
• except double task# in B and D, all Task# and card# don’t have line break and “space”(“ “).
• Only the double task # in B and D has line break
• Duplicated Task# (for different Cell) in D is possible
• Duplicated Card# (for different Cell) in E is possible
• Same Card# in the same cell is not allowed, but in different Cell is allowed.
• MATCH means data in B and D is exactly same.

Example:
B2: aaa D2: aaa bbb (Not matched)
B2: aaa D2: aaa (Matched)

Please let me know your question if you think I didn’t describe my request clearly.


Thanks for teaching,


Scott