Merge Rows and Combine Columns

[SaiJanani]

Hello, 

I am trying to achieve the below output. Lot of things need to happen.

1. Merge current row with the below row and display the output in the below row for Col B, Col C and Col D 

2. Merge Col E and Col F where I want to keep the 1st,3rd,5th row in Col F but want to merge and copy the data from Col E to Col F on the the 2nd, 4th, 6th row 

3. Same as above for Col H and Col I, but Col I doesn't have data on the 1st row

Below are the Input and Output:

Sample Input:

Col A	Col B	Col C	Col D	Col E	Col F	Col G	Col H	Col I
ABC123	1	123	648	963	ABC	BMN	428
DEF187	1	123	648	963	542	753	428	421
GHF197	51	789	324	423	XYZ	ERTS	157	LOP
HML321	51	789	324	423	698	658	157	357
LKH456	5	654	148	875	PQRS	WER	637	GHF
LMB879	5	654	148	875	698	6321	637	169

Sample Output:

Col A	Col B	Col C	Col D	Col E/Col F	Col G	Col H/Col I
ABC123				ABC	BMN
DEF187	1	123	648	963	753	428
GHF197				XYZ	ERTS	LOP
HML321	51	789	324	423	658	157
LKH456				PQRS	WER	GHF
LMB879	5	654	148	875	6321	637

[AngelosPachis · Accepted solution]

Hi @SaiJanani ,

Here's a workflow that does what you're looking for. The trick for the requirements for columns B-D is to group on all distinct values in those columns and also use the Last expression for column A in the summarize tool. For columns E/F and H/I, you will have to identify which rows are odd/even (you can do that with the modulo function) and then apply the logic with an IF statement

Hope that helps,

Angelos

[SaiJanani]

@AngelosPachis - worked like a charm, thank you