Multi row formula to target records as per mapping sheet

[Naga]

HI Team,

Please help with this requirement.

1. I have an input file from which I need to take only those records from the mapping file

2. Mapping got only one key record that I need to map

3. My key record in the input will have corresponding records in the input and I need only those records in the mapping.

4. I can able to identify the start and end for each set of records

Challenge and need

1. I need only those records in the input from mapping + their additional records tied to that mapping

2. my Start and end count of records differs

Input

column Name	Start end	Map
1*Key1	Start	1*Key1
2
3
4
5
6	End
1*Key2	Start
2
3
4
5
6
7	End
1*Key3	Start	1*Key3
2
3
4
5
6	End

Mapping

Mapping file

1*Key1

1*Key3

1*Key4

1*Key5

1*Key6

Output

column Name	Start end	Map
1*Key1	Start	1*Key1
2		1*Key1
3		1*Key1
4		1*Key1
5		1*Key1
6	End	1*Key1
1*Key3	Start	1*Key3
2		1*Key3
3		1*Key3
4		1*Key3
5		1*Key3
6	End	1*Key3

Thanks
Naga

[atcodedog05 · Accepted solution]

Hi @Naga ,

Here is a workflow for the task.

Input: Table given by you.

Output: as expected

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[atcodedog05]

Happy to help 🙂 @Naga 

Cheers and Happy Analyzing 😀

[Qiu]

@atcodedog05 
You are on fire just like you avatar!😁