Hi there,

I have a drop down list which refers to a range of data.
As far as I understood, the range of data has to be defined vertically (in a
column) to be used by the drop down list. My issue is that the range of data
I would like to refer to is set in a row.. How can I link the drop down list
to this horizontal range (ideally without copy pasting the range with paste
special Transpose)?