How to pivot up the data?

Hi,

You can use Query activity and Enrichment in a workflow to change your data set and get result in above format. Try below steps

A) As an example I have created a schema name as cus:pivot

B) Create a workflow like below 

i) Query activity

ii) Take the enrichment activity and make the self join with same table with the help of 1: N join while giving join condition

While adding the data please make sure to add column(No. of records to retrieve as per your convenience (By default it will be max 3 rows) ). So it will create multiple enrichment table based on your records to retrieve. In below example since I have two values so I have selected two

Add your data from these different temp enrichment table and result will be like below

Hope this helps.