Filling the columns based on Amount column values

Question

Hello, Hope everything is going well

Kindly I need your help in this exercise.

After extracting the data from XML and selecting the needed columns I got something looks like this picture

I need to fill column 1 with the value 55, column 2 with value 63, column 3 with value 0, and column 4 with value 8.

In other words, thats only a sample of a huge data i have, I need to fill col1 with the value corresponding to Amount column 1st row. Fill col2 with the value corresponding to second value in the Amount column and so on...

What is the best practical solution to do this.

I really appreciate your help

Thank you so much

DataNath · Answer

@MBahsoun would this be suitable? The workflow assigns each row a RecordID, before then creating a new header name and cross-tabbing the data to suit. This will be dynamic to adding as many rows as you want and will create a new field each time with the value populating automatically.

Create and populate column from row #.yxmd