I am having following data set [image] Now I want to filter the data in new table where I want to see how many jobs person 1, 2 and 3 is working on Ex - person 1 is working on job 1 and job 3.

Dear @Video_by_Pro , I amended your doc and put some explanations. If something remains unclear, feel free to get back to us :rocket:

How to combine data from diffrent colums in one

Jean_Pierre_Traets July 10, 2020, 4:47pm 2

Welcome to the community

With concatenate as explained in this post you will be able to to solve this.

Topic		Replies	Views
Help with multylook ups/filtering	4	97	October 9, 2025
Union of 2 Tables	4	1290	November 22, 2018
Aggregating data about my organizations Tips and Hacks	3	305	March 11, 2024
JOIN 2 or more tables	2	1966	March 1, 2019
Merge Two or More Tables into One Coda Basics	3	276	December 4, 2024