How to move data from this col arrangement to another col arrangement

Question
1

I several files.
File A is my template into which I need to insert data
File B, C, D all have different col arrangements.
I need to take File B for example and move data into the col arrangement to File A.

A more specific example
Here is a screenshot with File A on top and File B on bottom. The red arrows point where cols from file b need to go into file A. Brevo Reports example 2024-...

Hopefully someone has some tips on how to achieve this efficiently. Thanks!

2

You can do this using the Stack transform.

  • Input A and B (I’ve used the clipboard in the example, but you will want to use files - just drag the files to the center pane)
  • Select B and click the Rename Cols button on the left
  • Rename the columns you want to keep in B, to match A
  • Select the newly created Rename Cols item and click the Remove Cols button on the left
  • Remove unwanted columns by unchecking them
  • Select A and the newly created Rename Cols item and click the Stack button on the left
  • Set stack to Align column names by Header name
  • Select the newly created Stack item and click the Output button on the left
  • Choose the output format you want (e.g. Excel)

image
image965×317 66.1 KB

goodlab.transform (3.6 KB)

See also: