How to transform this data

Hi All,

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.

Thanks,

Amit Belagali

HELPNEEDED.xlsx

Datasets

Developer

Tips and Tricks

Common Use Cases

Transformation

Preparation

Optimization

Expression

Accepted answers

LordNeilLord

Hey @AmitBelagali

Sorry for the delay

I've attached an example of how to approach one of the sections, mostly reliant on Multi-Row formula. Use this to get you started and see if you can figure out the rest

YouGov.yxzp

All comments

LordNeilLord

hey @AmitBelagali

There are no screens attached.

But have you looked into the crosstab tool?

AmitBelagali

Hi @LordNeilLord,

Tried that Neil. But in vain. Could you please suggest us a different way?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703