Formatting columns into rows by matching with each entry

dianastate

Hi!

I would need your help with this problem:

I have an excel file that I want to automate using Alteryx. The file contains the daily forecast, per partner, per country.

• The columns headers: date and the corresponding retail week.
• The rows names: partner name and the country.

	Date	e.g. Day 1	e.g. Day 2	e.g. Day 3
	Retail Week	e.g.1	e.g. 2	e.g. 3
Partner	Country	Forecast	Forecast	Forecast
e.g. Tesla	e.g. UK	e.g. 111	e.g. 123	e.g. 134

I need a workflow which transpose the dates into rows, and matches the partner, country and retail week data, with the corresponding date:

Date	Retail Week	Partner	Country	Forecast
e.g. Day 1	e.g.1	e.g. Tesla	e.g. UK	e.g. 111
e.g. Day 2	e.g. 2	e.g. Tesla	e.g. UK	e.g. 123

I have attached the input excel file and a screenshot with the desired output. 

Thank you a lot! 😁

example.xlsx

example_input_output.png

FrederikE

Hey @dianastate,

This should work. I separate the headers and then rejoin them as their own columns. Then the transpose is quite simple. 

New Workflow6.yxzp