Solr - splitting a field value into multiple rows in the index

Question

Is it possible to do so with a transformer (data-fonfig.xml) or in schema.xml somehow?

For instance, my database returns rows with two columns: IntegerColumn, VarcharColumn

1, 'small'

2, 'medium'

3, 'small, medium'

I'd like to add the 3rd row as two separate entries in the Solr index.

1, 'small'

2, 'medium'

3, 'small'

3, 'medium'

Is this possible? If so, how do you do it?