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.
We have a scenario wherein we have few rows that needs to be transformed as columns. Please find attached screenshot. In this, we have Region, Sector, Filter, Metric Filter, Population and Brand as rows and below that we have data as column. We need to make all these as columns with date.
Also, like this we have around 10-12 sheets with same structure.
Could you please help us on this?
I have attached both input and output file screenshot.
Without an actual example of the data it's going to be hard to give you a full solution...but looking at it from the pics...this is probably going to need some muli-row formula tools and a few transposes first.
Can you attach an example of the actual data (or that mock up you just screen shotted)?