i want to copy all columns on the right side in a certain structure beneath ohther columns. To be more precise about the structure, I have on the left side my testdata, next to it my reference data and on the right side my result (wheater they are the same or not). I made this comparison for many different “attributes” (see column headers) and now I just want to put them in that structure i described.
Here is an example:
In the end i should get a long table with 6 columns somehow like this:
Row ID | Columnname_test (Attribute) | Columnname_reference (Attribute) | Column Value 1 | Column Value 2 | Result (Comparison)
I tried it with pivoting and transformation but it did not work out
I hope somebody can help me out.
Thank you very much!