Consolidation of data

Hi,

I have two files were all the fields are same except only 2 different fields i.e. Order and WBS Order. I want to consolidate both files under same receiver with order and WBS order as well. Attached file has the requirement, can any one please help me with this.

Consolidation test_V1.xlsx

Reporting

Accepted answers

AngelosPachis

Hi @bnari12

From the looks of it I guess that can be solved by sorting as necessary, but your blanks might cause you an issue.

Have a look at the attached workflow, it essentially sorts your columns as necessary and bring back the blanks in the end if you want a cleaner view when exported to an excel file. That's totally up to you

Workflow

Screenshot 2020-10-28 115205.jpg

Output (Excel)

Screenshot 2020-10-28 115252.jpg

Hope that helps,

Regards,

Angelos

example.yxmd

All comments

Qiu

@bnari12
What you are asking can be easily done by Tile Tool, but the blanks are killing me.

1028-bnari12.yxmd

Qiu

Are you still need blanks for output?

bnari12

i will check and let you know, mean while i will check the details you shared and come back to you.

Thank you so much !

bnari12

Hi, i dont want the header details after the first row of the customer like below, the header lines should come only for the first line and then from service column it should be same.