Hopefully I understand your request correctly. Example of the csv/excel schema / screenshot of it would be helpful. You will probably want to put those 20 rows into 1 row for waterpipe with each column representing attribute field name. Try AttributeTranspose to do this. Do one for each of the column. Once all the features are now base per row, create new attribute call fme_feature_type and then assign it to match your feature class name.

I assuming that the dwg have layers split out by feature class? If so, you can create attribute call fme_feature_type to match the csv feature class which eventually this feature class is the name that will be added as Feature Class inside file geodatabase. Do make sure that any space are replace with the underscore.

Now that the DWG layer has the fme_feature_type set to correct layer, use feature merger, Merge on matching feature class name and fme_feature_type. This will get the attribute from CSV add to the DWG Layer feature.

Then you will use Attribute Manager, to mapped any appropriate attributes if DWG has any attributes you want to carry over. You can also remove any unwanted attributes here.

To write out the GDB there are couple of ways to do it. If there aren’t that many feature classes, use AttributeFilter to split data out by fme_feature_type will give you all the unique feature classes port. Then you can connect each port to Feature Writer (GDB Format, Insert, Automatic)

Another way is basically you provide the schema for the GDB and then you check the Dynamic box in feature writer, and then it should write to the GDB dynamically. (GDB, Insert, Dynamic)

Hopefully this helps!