COMBINING TEXT VALUES TO 1 CELL ON SEPERATE WORKSHEET

Occasional Visitor

Worksheet has 4 seperate columns to track payments from different sources.  I need to combine all the "titles" of these cells into 1 cell to indicate the "source" of the payments.

 

LaurieCS3705_0-1670018569113.png

 should appear in "SOURCE" cell as follows for each provider:

 

Medicare, Medi-cal, Medpay, Patient Paid (combined in 1 cell)

 

LaurieCS3705_3-1670018751445.png

I manually typed these values into the cell "SOURCE" for example purposes.

I tried using the "&" and "CONCAT" commands but it didn't pull the info over.  Not sure what I'm doing wrong.  The tutorial only uses 2 cells and when I do just 2 cells I no longer have the ability to add to the formula.

Please help!!

 

1 Reply
Those options SHOULD work (along with TEXTJOIN). I'm not sure why they aren't working for you and need to see the sheet and have more info to figure out. For example is this all in a big table and those 4 columns are all in that same table? What exactly are the formulas you tried? Is the "table" of data you are pulling from and/or putting the formula "Formatted as a Table"?