Fill a field with values from other fields

[OrlanViloria]

Hi, I am trying to get from a table like this: 

A new field that contains the records from other fields, something like this: 

Thank you! 

[jacob_kahn]

Try something that I did attached 😉

Using Transpose and Summary Tool

J

[OrlanViloria]

Okay, that helped, thank you! Now If I have also a file with dates and I need to combine the countries with every date how  could I do? Do you have any solution for that? 

Example : I have these two fields from different files:

       

And I need something like this 

Thanks!

[jacob_kahn · Accepted solution]

Is this what you are looking for?

Please like and accept as solution these replies if they help in your process 🙂

Thank you,

J

[OrlanViloria]

Yes, that is what I needed. Thank you!

[jacob_kahn]

Fantastic! Please let me know if you have any other questions 🙂

J