Merge three columns into one

Hi there,

I am trying to merge three columns of data into one. Right now my data looks like the below.. there are four columns under the same header "Type of requisition." I would like to merge all four columns into one column (see 2nd image). I'm not quite sure how I can do this with the transpose tool... Any help is MUCH appreciated!

Before Before

After After

Alteryx Question.xlsx

Best Practices

Transformation

Expression

Accepted answers

BenMoss

My approach would be slightly different but ends with exactly the same output. The attached workflow also is dynamic in case additional columns are added that should form part of the concatenation.

Dynamic Option.yxzp

All comments

Joe_Mako

How about something like the attached?

concat.yxmd

unknown

This can easily be done using the formula tool. Create a new field called "Type of Requisition - Calculation" and set it to equal this:

=Trim([Type of Requisition - Column F]+[Type of Requisition - Column G]+[Type of Requisition - Column H]+[Type of Requisition - Column I])

After this, deselect the old 4 columns with a select tool and you are done.

SeanAdams

Hey @koralynah - happy weekend.

I've mocked this up below - similar to the other posts on this. If you use a multi-field formula tool to remove the '[Null]' from the blank fields, and a quick formula to pop the remaining bits together, you're off to the races!

If this helps to solve the problem - would you mind marking this as solved, or if there are still questions feel free to reply and we can iterate with you.

Cheers

Sean

TestFlow.yxmd

BenMoss

My approach would be slightly different but ends with exactly the same output. The attached workflow also is dynamic in case additional columns are added that should form part of the concatenation.

Dynamic Option.yxzp

koralynah

Thanks Ben Moss!!! It worked!

Cliriano

This is an example of a simple and best solution approach. It dynamically consolidate multiple columns in one.

Thanks.

DarioDS

This is a great solution - is it possible to do this for multiple sets of columns that need to be merged? For some reason I'm getting a funny doing it by formulas, so I'd like to adapt this rather.

By multiple sets, I mean I'm importing 25 different sheets which each have different headers for "First Name", "Last Name", "Address" and a whole bunch more.

PRatikChugh007

Am trying below however not working any other easy solution?

emenendez2

I am trying to concatenate 3 columns into 1 new column separated by "/" by the issue is when certain cells are blank the output in the new column looks something like: Phone Number//Home Address. Among the 3 columns, some of the cells will be blank but in this case, I would like the output to show instead as Phone Number/Home Address. Any ideas?

LoganMeriwether

A simple solution to this problem (though I don't want to say most effective) would be to use the Formula tool after with the "Replace" function.
For example, if you had a column [key] that contained the content HELLO---WORLD and you only wanted it to say "HELLO-WORLD" you would type
Replace([key], "---", "-") and then run your workflow.
Your example would look like this: Replace([Column Name], "//", "/")

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335