Grouping certain value by colomn

[manggo]

Dear Forum

Need help please.

I have entries raw data that not in order like this.
Entry No 1, Car, Duck, Cabbage
Entry No 2, Bird, Banana
Entry No 3, Plane, Bird
Entry No 4, Bike, Pea
Entry No 5, Pear
Entry No 6, Car, Duck, Banana
Entry No 7, Duck, Bike

I want all entries will grouping according to categories (by colomn) TRANS, FAUNA, FLORA as like this :

NUMBER TRAN FAUNA FLORA
================================
Entry No 1 Car Duck Cabbage
Entry No 2 None Bird Banana
Entry No 3 Plane Bird None
Entry No 4 Bike Pear None
Entry No 5 None None Pear
Entry No 6 Car Duck Banana
Entry No 7 Car Bike None

How I put the formula in excel please ?

Any help would very appreciate ..

The excel I put here :
https://drive.google.com/open?id=1rQ5lHNx-FYfdKCbulo2frzY7g5-8mAA2

Regards,
Manggo Manggo

 

[manggo]

Dear Peter

What excel version do you recommend that working with TextJoin formula, please ?

I am using Microsoft Excel 2010 Professional Plus, on Windows Server 2008 R2.

I will try with different windows version and different excel version also.
I will let you know.


Cheers
Manggo Manggo

 

[Peter_SSs]

What excel version do you recommend that working with TextJoin formula, please ?'

TEXTJOIN requires more recent versions.
See here: https://support.office.com/en-us/article/textjoin-function-357b449a-ec91-49d0-80c3-0e8fc845691c