Align columns based of column names

Hello Folks,

I need to align columns horizontally for a file that I am working on.

In the example you can see I have two columns A and B. I have done two operations on each column, that is given a comment to the column and given data_score. But the Columns are next to each other and the operations are next to each other. Expected output is I want the columns and its operations next to each other.

I do not want to use the select tool to reorder the columns as in the real scenario I have around 50 columns and 4 operation in each column. One solution I can think of is - Trasnpose the table and sort it based on column names then undo the transpose using cross tab tool, but I am not able to configure.

Any help would be really appreciated.

Regards,

Sanchit

example_capture.PNG

Example.xlsx

Datasets

Developer

Developer Tools

Transformation

Preparation

Accepted answers

Qiu

@sanchitsharma4
This should at least work for your sample data, since the column names are in alphabet order.

0410-sanchitsharma4.yxmd

All comments

Watermark

Is this a process you'll be repeating? Will it always have the same 50 columns with the same 4 results per column? (also: by column I assume you're talking about a/b/c/d.../etc n50) so you ultimately end up with 200 columns?

Watermark

Here is a simple flow to do what you want with the data provided. This would potentially need to be modified based on exactly what the column names are and other details that could give you answers slightly different than you want. The concept would be close to the same you'd just need to add some variance in for the real data.

If this gets what you need, can you please give it a like and click the button for solved. Thx.

Resort Columns.yxmd

Qiu

@sanchitsharma4
This should at least work for your sample data, since the column names are in alphabet order.

0410-sanchitsharma4.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703