Hi, I want to transpose / unpivot my data based on multiple rows. FOr example my data looks like: Gross RevenuesSituationLTM NetherlandNetherlandNetherlandUKUKUKGermanyGermanyGermany EuropeEuropeEuropeEuropeEuropeEuropeEuropeEuropeEurope 202020212022202020212022202020212022Flyer1352501895611362429904561371Flyer245918642862181731412191936Flyer358870160335667443883955122 I need to delete the first and third row and then unpivot data based on Country and Year. So that my output contains only four columns Flyer#/ Country/ Year/ Value. My desired output should look like: FlyerCountryYearValueFlyer1Netherland2020 Flyer2Netherland2020 Flyer3Netherland2020 Flyer1UK2020 Flyer2UK2020 Any suggestion on how to proceed with the task? Thanks in advance :) Input sample.csv output sample.csv

Transpose / unpivot multiple rows to columns

Hi,

I want to transpose / unpivot my data based on multiple rows. FOr example my data looks like:

		Gross Revenues	Situation	LTM
	Netherland	Netherland	Netherland	UK	UK	UK	Germany	Germany	Germany
	Europe	Europe	Europe	Europe	Europe	Europe	Europe	Europe	Europe
	2020	2021	2022	2020	2021	2022	2020	2021	2022
Flyer1	352	501	895	611	362	429	904	561	371
Flyer2	459	186	428	621	81	731	412	191	936
Flyer3	588	701	60	335	667	443	883	955	122

I need to delete the first and third row and then unpivot data based on Country and Year. So that my output contains only four columns Flyer#/ Country/ Year/ Value.