Concatenate based on pre-existing multiple rows

[CDF234557]

Hi! I am trying to think of how to create a concatenated column from data like the below: 

Date	A	B	Flag
1-Jan	A	B	1
2-Jan	A	B	1
3-Jan	A	B	1
5-Jan	A	B	0
2-Jan	C	D	1
3-Jan	C	D	1
4-Jan	C	D	1
6-Jan	C	D	0

To the following: 

Date	A	B	Flag	Output
1-Jan	A	B	1	1-Jan - 3-Jan
2-Jan	A	B	1	1-Jan - 3-Jan
3-Jan	A	B	1	1-Jan - 3-Jan
5-Jan	A	B	0	0
2-Jan	C	D	1	2-Jan - 4-Jan
3-Jan	C	D	1	2-Jan - 4-Jan
4-Jan	C	D	1	2-Jan - 4-Jan
6-Jan	C	D	0	0

Note - it is easy to filter out the flag if that makes the equation easier. Still can't figure out what I am missing... Thanks!!

[fmvizcaino]

Hello once again @CDF234557 ,

Almost real time answer hahahahh. Attached is a workflow that does the job. 

Let me know if that works for you.

Best,

Fernando V.

[CDF234557]

Hi Fernando! Thanks(yet again!!). To add a layer of complexity to this, I am not sure first and last will work as I think I may have the same instance multiple times, e.g.

Date	A	B	Flag
1-Jan	A	B	1
2-Jan	A	B	1
3-Jan	A	B	1
5-Jan	A	B	0
2-Jan	C	D	1
3-Jan	C	D	1
4-Jan	C	D	1
6-Jan	C	D	0
7-Jan	A	B	1
8-Jan	A	B	1
9-Jan	A	B	1

Here I would want the output to be:

Date	A	B	Flag	Output
1-Jan	A	B	1	1-Jan - 3-Jan
2-Jan	A	B	1	1-Jan - 3-Jan
3-Jan	A	B	1	1-Jan - 3-Jan
5-Jan	A	B	0	0
2-Jan	C	D	1	2-Jan - 4-Jan
3-Jan	C	D	1	2-Jan - 4-Jan
4-Jan	C	D	1	2-Jan - 4-Jan
6-Jan	C	D	0	0
7-Jan	A	B	1	7-Jan - 9-Jan
8-Jan	A	B	1	7-Jan - 9-Jan
9-Jan	A	B	1	7-Jan - 9-Jan

Any thoughts or suggestions?  

[fmvizcaino · Accepted solution]

Hi @CDF234557 ,

Attached is a workflow that does the job.

Let me know if that helps.

Best,

Fernando Vizcaino