Dear All,

I have a table with 20 columns.

This is an example with only 10. The cells are filled with different brands.

Row ID |
Q1 |
Q2 |
Q3 |
Q4 |
Q5 |
Q6 |
Q7 |
Q8 |
Q9 |
Q10 |

1 | A | B | C | D | E | F | G | H | I | J |

2 | B | A | D | F | I | J | L | M | Z | P |

3 | M | J | I | K | L | A | C | B | F | D |

I need a table with only 2 colums and the colums from above processed as follows:

start |
target |
comment (not a column ;-)) |

A | B | start = Row 1, Colum Q1; target = Row 1 Column Q2 |

B | C | start = Row 1, Colum Q2; target = Row 1 Column Q3 |

C | D | start = Row 1, Column Q3; target = Row 1, Column Q4 |

D | E | ... |

E | F | |

F | G | |

G | H | |

H | I | |

... | ... | |

F | D | start = Row= 3, Colum Q9; target = Row 3; Column Q10 |

I got the result with with various Column Filter -, Renaming - and Conenctrate-Nodes.

But I thouhgt there must be an easier way to get the result.

Has anyone an idea and can help me?

Cheers,

Chris