Assuming you have the 'Example 1' description as the first row in your table, you could try something like this:
load * Inline
RowNo() as Id,
if (WildMatch(CODE,'EXAMPLE*'),CODE,peek(Teste)) as Teste
drop table fakedata;
Since there's nothing to compare in the columns, I would assume you have some structure that the first row has the defining CODE, in this case 'Example 1'.
Attached the file I used.
Sample.qvw 151.8 K