Consolidation of data

[bnari12]

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.

[Qiu]

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

[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.

[AngelosPachis · Accepted solution]

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

Output (Excel)

Hope that helps,

Regards,

Angelos

[bnari12]

Hi,

i got the required output with your code, thank you so much !

Regards

Naren