I came to this post looking for what I believe Emir (OP) wanted to do, which is: Have the lookup field treated as a Multiple select field for downstream usage, in particular, I want to use the result of the lookup field as rows in a pivot table, but ...