Transpose data form columns in rows matched with a key
Hello to every one,
I have a table with thousands of records(rows) with data in 3 columns.
In the first column I have the customer id and in the other columns their invoices numbers and the date (may the customer id appears more than one times).
I want to transpose the invoice numbers and match them with the customer id horizontally.
For example, I want to have a transformation as in the picture.
I 've tried with PQ but w/o successful results.
|