Dear Ex(cel)perts,
I have a rather complex question.
To begin with: I have built a model where by typing in an identifier code, different rows of data are returned (used index match here). There are three categories of data that usually have different lenghts of rows. At the moment I have placed those three categories next to each others (think city,street,region).
I would like to place those three categories underneath each other. However, because with every different identifier, the lenght of data varies, i would like to know how to automatically determine the last row of the first set of data and then automatically start the next field underneath that row.
Thank you so much in advance.
I have a rather complex question.
To begin with: I have built a model where by typing in an identifier code, different rows of data are returned (used index match here). There are three categories of data that usually have different lenghts of rows. At the moment I have placed those three categories next to each others (think city,street,region).
I would like to place those three categories underneath each other. However, because with every different identifier, the lenght of data varies, i would like to know how to automatically determine the last row of the first set of data and then automatically start the next field underneath that row.
Thank you so much in advance.
