Moving data to rows

Question

Hi All

I am trying to move data into one row like below

trying to use text tables and transpose - seems no luck

thanks for you for help

FromToTime:Time: September 2018: $October 2020:September 2018: $October 2020: Status:Status: Hired : NotHired : Not Start:Start: September 29  2018: $December 5  2018:September 29  2018: $December 5  2018: Completion:Completion: March 31: $January 1:  2021March 31: $January 1:  2021 2nd Completion:2nd Completion: March 31: $January 1:  2021March 31: $January 1:  2021

AngelosPachis · Accepted Answer

Hi @Marp ,

One way to do it is with the following workflow.

What it does is it assigns a record id to each row of data, then groups them by two and brings them side by side with a cross-tab tool.

With the formula tool that follows you concatenate the values together to have them in a single string, and then you just have to remove every second occurrence of the same string.

Hope that helps, let me know if that worked for you or if you have any questions.

Cheers,

Angelos

echuong1 · Accepted Answer

Another way of achieving this is by creating flags to identify the groups of records, then a cross-tab to pivot. A formula can concatenate the two pieces together.