Moving data to rows

[Marp]

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

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

[AngelosPachis · Accepted solution]

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 solution]

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. 

[Marp]

Thank you both for quick response - worked like a charm!

you guys are awesome