Transpose rows to a blank space

[araquecastro]

Hell people

I have the following dataset:

I want to turn it into this arrangement:

I really appreciate your help.

[rzdodson]

@araquecastro will the number of rows in your original data set ever change between the seqments? If not, this should be rather straightforward.

When able, would you mind posting the original input file - I think it is an xlsx file - so I can knock this one out for you?

[CoG]

It may just be a typo, but why do the Total2 values change rows (See last few rows)? The -23802916.67 goes from last row in Total2 to 3rd to last.

Are you trying to join on [Grupo] = [Right_Grupo]? Or are you joining by index (essentially just filtering out the Nulls from above)?

[Qiu]

@araquecastro 
If you are really want to just translate the right part up in order, we can do something like this.

I do think there is something incorrect in your transpose procees, maybe you can show us?

[araquecastro]

Hi  everyone, thank you so much for the quick reply 

rzdodson I'm attaching the excel file for your review, and the answer is yes the number of rows in the original data set will change between the seqments in the future.

AndrewDMerrill essentially I'm just filtering out the Nulls from above and trying to match the rows.

And @20 - Arcturus. This workflow shared has almost done the trick but as you mentioned for some reason that I ignore the input file has that difference between the Grupo 06503-C922-2300-09604-E901-ZZ-USD-2236 and the other Right_Grupo 06503-C922-2300-09604-E901-ZZ-USD- where the last four digits are missing but the values in VTotal and Total2 Match. I'm attaching the excel file with the input data and the final result I want to obtain. Some comments about it:

POC Entries and Commission are permanent titles same as Amt and Acer First.  Is like the final report formatting.

The dates 12/4/2023 are assigned depending on the File Name

Columns Four Digits and Diff I believe can be calculate creating new columns using a formula tool with function trim and a subtraction operation.

I really appreciate the support you can provide with this.

[CoG · Accepted solution]

What are you actually joining on? Here is another sample that may work better:

[araquecastro]

This one works great @CoG. Thanks for the reply. I'll check it as solved.