Hi all, does anyone know how to go about placing a specific column under another column? For example placing column D under column B while still keeping the first two columns consistent. Before NumberNameAB1John 1 489Barb 43 271000Willy 60 421001Steve 98 94 After NumberNameA1John 12Barb 433Willy 604Steve 98NumberNameB1John 482Barb 273Willy 424Steve 94 Thanks

How to place multiple columns under one column

Hi all, does anyone know how to go about placing a specific column under another column? For example placing column D under column B while still keeping the first two columns consistent.

Before

Number	Name	A	B
1	John	1	48
9	Barb	43	27
1000	Willy	60	42
1001	Steve	98	94

After

Number	Name	A
1	John	1
2	Barb	43
3	Willy	60
4	Steve	98
Number	Name	B
1	John	48
2	Barb	27
3	Willy	42
4	Steve	94

Thanks

Transformation

Accepted answers

ddiesel

Hi @danielsnook!

Try this setup and see if it works for you. In your Input Data tool, make sure to check the box in setting #6 for "First Row Contains Data" as the field names are treated as records to match your desired output.

How to place multiple columns under one column ddiesel.yxmd

All comments

kat

Hi @danielsnook

Have a play with the transpose tool. I think you'll struggle with those repeating field names, but it might be what you need.

Cheers

Kat

ddiesel

Hi @danielsnook!

How to place multiple columns under one column ddiesel.yxmd

ThizViz

I'll toss out another possibility, but it will depend on how many columns you have.

First, in your input tool, check the "first row contains data" box.

Use a select tool to pick only Number, Name and A, but change the name of A from F3 to Value

Copy and paste that select tool (connect to your input) and change your selection to Number, Name and B. Again, rename column "B" (F4 or whatever) to Value.

Continue until you have all your columns, then union all.

Now your data is arranged as you've described and you can rename your column headers any way you want.

It appears that your data is structured according to some pre-defined report, but just in case you ever want to use it in Tableau, for instance, there's a better way. I'll whip up an example for you.

ThizViz

Here's a little bit different way to prepare the data in case you need to present it in another tool.

PrepForTableau.yxzp

ThizViz

Here's a little bit different way to prepare the data in case you need to present it in another tool.

PrepForTableau.yxzp

danielsnook

Thanks this worked out great! The transpose tool was giving me a little bit of trouble before, much appreciated.

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335