How to concatenate values from two different rows into one row ?

Question

Hello Everyone,

I ran into some situations where I need to merge data from two rows and have it under a separate row. For example - One row contains Quarters like Q1, Q2, etc and the other row has Years. I want to have separate rows which should read "Q1 2010" and so on. Attaching the sample file.

Can somebody help with this?

MetricRegion/Country20102010201020102011201120112011  Q1Q2Q3Q4Q1Q2Q3Q4Family Monthly Active People (MAP)*         Total MAP (M)NA354243344545769876 EU444444342442344490 APAC464646465324623446 ROW2343243247834776776342 WW475134312335234123123

Best Regards,

H Gola

Book1.xlsx

Matt_D · Accepted Answer

Hi, here is one way, I've made a massive assumption that you want the data in a tidy table, if this is not what you want please specify.

Thanks,

Matt

grazitti_sapna · Accepted Answer

Hi, another way to get the desired output.

I hope this helps!

Thanks!