This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I would like to have this formula be able to adjust if data changes and there are new columns such as Level014 and Level 015. Right not these fields are not appearing in the crosstab being created because they have no data but that could change tomorrow.
There are many ways to do that, but I need to understand a little more about your workflow in order to provide the better solution for you. Would you be able to share at least a print and how the data is coming for this formula, please?
it is coming from a Cross tab tool... let me know if this helps.
the original data is transposed another field is joined then it is put back together in a cross tab to create the new data. Only fields where there is at least one value are getting created which is why I need the formula to adjust if it changes in the future.
You can use a combination of cross tab and transpose to achieve this. You would essentially use a transpose tool to get all of the values into one column. You can then use a cross tab tool with the concatenate method to combine values separated by commas. See attached for an example. Let me know if this helps!