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

[harshit1795]

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?

Metric	Region/Country	2010	2010	2010	2010	2011	2011	2011	2011
		Q1	Q2	Q3	Q4	Q1	Q2	Q3	Q4
Family Monthly Active People (MAP)*
Total MAP (M)	NA	354	243	34	45	45	76	98	76
	EU	44	44	44	342	44	234	44	90
	APAC	46	46	46	46	532	46	234	46
	ROW	234	324	324	78	34	776	776	342
	WW	475	13	43	123	35	234	123	123

Best Regards,

H Gola

[Matt_D · Accepted solution]

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 solution]

Hi, another way to get the desired output.

I hope this helps!

Thanks!

[harshit1795]

Thanks a lot. This is what I was looking for 🙏