Create New Column With Information from Different Fields

Question

Hi Everyone I'm stuck in the middle of a workflow where I need to transfer some fields into an Output Excel Template. Below I'm pasting the data I have so far, which I'm attaching as well. I highlighted with colors the fields I need to transfer to make it easier for explanation.

Current Data

I need to move this colored fields into the template I'm pasting in the following image:

Final Template

Below is an image of the data with comments about the data origin which is included in the Excel files attached:

Data Origin Comments

I'm also attaching the excel files with the Input data and the Output final Template. I really appreciate the help you can give with this.

Best for all.

Working File.xlsx

Template Final.xlsx

AnnaLawrence · Answer

I isolated the rows required in the order required, transposed the data, and unioned it back. I included comments in the workflow. Hope that helps!

Create New Column With Information from Different Fields.yxzp

RaphaelSilva · Answer

If your data structure is always the same, you can extract the columns in want, split in individuals rows and stack them together respecting the header, order and blanks, then you can you append the two columns to the other database.