How can we achieve this output.

[gaitonde25]

input:

output:

[gaitonde25]

input:

[binuacs]

@gaitonde25 one way of doing this with the Row-Generate tool

[gaitonde25]

i need data from 2001 to 2003 and 2006 to 2008.

[IraWatt · Accepted solution]

Hey @gaitonde25,

Here's another way of doing this:

Let me know if you need to add the ,'s in.
HTH!
Ira

[binuacs · Accepted solution]

@gaitonde25 Just noticed the expected output and based on that updated my workflow