Greetings,
I am completely new in Alteryx and would like to join many tables present in the same Excel Sheet.
Basically, I have the data like this:
Product Price Country1 Product Price Country2 Country3
P1 55 1 P98 58 2 3
P5 30 2 P3 20 0 1
Each table has more than 500 records and approximately 10 columns. Under the country column, we have the units for that country.
The aim if to transform all this in one table and one file with a column country having the country and a column units having the units.
I join a copy of the type of file.
Any idea of how this can be done?
Thank you very much in advance.
