MULTI-ROW FOR SECUENCE PUTTING NULL IN SECUENCE OF 2 STEPS

[aden08]

Hi community, I need your help. I have a sequence of data, but I only need it to repeat three times, not two as you can see in the attached screenshot.

If you have any advice for this issue, it will be very helpful to me.

[caltang]

I do not understand your request - can you elaborate further and provide some detailed breakdowns?

In addition, can you provide some sample data instead of a screenshot? Thanks!

[aden08]

Thank you, here I leave you more details. If you can see in the screenshot, there is a sequence 1,2 = 1. Then another sequence is presented, 4,5,6 = 1. I want to keep only the sequences that appear 3 times, and for those that appear only 2 times, insert a null().

[caltang · Accepted solution]

Okay! I understand you now. Please find attached.