Multiple headers for one record

[akvsachin]

Suppose headers as

| collection_id | collection_name | workflowid_1 | worflow_2 | ... workflowid_255 |

| id1 | xyz | null | 56asd78af | 89afusd | 89asdc | null | ....| null |

| id2 | ghi | 89vad | null | null |... | null |

| id3 | bhu | 98uzvdvu | null | null | ... | null |

I need the records as

| id1 | xyz | 56asd78af |

| id1 | xyz | 89afusd |

| id1 | xyz | 89asdc |

| id2 | ghi | 89vad |

| id3 | bhu | 98uzvdvu |

Can anyone please help me with this

[binuacs]

@akvsachin can you provide a proper delimited test file?

[CoG · Accepted solution]

I'm not sure I understand your exact input structure and output, but the Transpose Tool is all that you need to achieve the general format, then the Filter Tool to remove nulls.

Hope this helps and Happy Solving!