How to combine column values

[samxhander09]

Hi Community,

I've been doing an exercise and I couldn't figure out how to combine all row values from different columns into one.

Example:

How do I get this output?

Apple         Orange

12               1

34               2

23               3

                  12

Thank you everyone.

[PhilipMannering]

Hi @samxhander09 

I would try something like this...

[gawa]

hi @samxhander09 

When handling "horizontal" shape data like this, using transpose/cross-tab is the best.

Please reference to the attached workflow.

[Raj]

In this case both the workflows work fine but i suggest to go with @PhilipMannering as the workflow is dynamic and will work if any additional fruit is added

[samxhander09]

I'm attaching a sample input, I couldn't seem to make it work.

I wanted to output like this: 

Exp        Dis

1513      (28,959)

403        (1315)

Combine all Exps values into one column same with Dis. Appreciate all the help so far.

[samxhander09]

Hi, I couldn't seem to make it work. I wanted to output it this way:

Exp               Dis

1513            28959

403              1315

Just basically have two columns with all the values in order from 1-9. I have attached the sample input for reference.

Thank you.

[samxhander09]

Hi, I couldn't seem to make it work. I wanted to output it this way:

Exp               Dis

1513            28959

403              1315

Just basically have two columns with all the values in order from 1-9. I have attached the sample input for reference.

Thank you.

[samxhander09]

Hi, I couldn't seem to make it work. What I wanted to output is two columns for Exp and Dis with the corresponding row values in order from 1-9.

I'm attaching an input sample for reference, appreciate the help.

[PhilipMannering]

@samxhander09

Do you expect the output to look something like this?

[samxhander09]

Hi, yes. This is how I want them to output.