Move Row Data To Columns

[erickastupart]

Hello!

Can someone help me transform data?  On the circled input data, I need to move the dates from each row to 3 date columns.

Below is how the input data looks and how the output should look.

Thank you.

[ShankerV]

Hi @erickastupart 

One way of doing this.

[ShankerV]

Hi @erickastupart 

Step 1: Input

Step 2:

Step 3: 

replace([_CurrentField_],"_","/")

Many thanks

Shanker V

[erickastupart]

Hi @Shanker V,

I don't have the concatenate option.

[Qiu]

@erickastupart 
In your case, you can use Sum option, I assume.

[erickastupart]

Hi,

I've used the Sum option and followed the remaining suggested steps, however the dates are still in the columns.

The example I attached may have been too basic.

Below is the output with the suggested steps.  I already had some column dates and amounts, however the dates in the Comparison Period need to appear as column headers for the amounts in the Comparison Period Amt column.

Thanks,

[Qiu]

@erickastupart 
Can you kindly share a sample data as above?

[erickastupart]

New sample data is below: