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 am wondering if there is a more efficient way of doing this than the approach I'm takign
I have a workflow where values that I want to consolidate into a single column are spread across multiple - for example in the format Fruit (1), Fruit (2), Fruit (3) - I would want these to appear under one column labelled Fruit.
Is there a way to do this using a macro that looks for similar column names and transposes these one at at a time, or is the best solution simply to transpose one at a time? The columns might change in future and it would be good to be able to have workflow that doesn't have to be updated manually.
The extra complication is that for e.g. Fruit (1), Fruit (2) there is an extra variable, Fruit type (1), Fruit type (2) which needs to be associated with the Fruit column