Hello!
I need to combine multiple columns of data into a single value. For example, if you look at the attached file there are 8 separate rows describing the subject's condition and trial (columns A, B, C, D, G, H), I need all of this information represented within a single name (M42_None_1__Building_Kansas_1back).
Hi -
Why don't you just concatenate the cells with another cell that has your "_" divider in it? Formula in Cell J2 looks like this:
=A2&$K$1&B2&$K$1&C2&$K$1&D2&$K$1&E2&$K$1&F2&$K$1&G2&$K$1&H2
K1 is where I entered _
The result is:
M42_None_1_Building_0.099649719_20_Kansas_1back
Hope that helps.
____________________________________________
If this has solved your problem, please edit the thread title to add the word [SOLVED] at the beginning. You can do this by
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved
If I have been particularly helpful, please "bump" my reputation by pressing the small star in the lower left corner of my post.
That looks like what I want to do; I just am not super excel savvy on how to complete such a thing.
Did you attach a file? I don't see an attachment.
Or another option in J2:
=TEXTJOIN("_",TRUE,A2:D2)&"_"&TEXTJOIN("_",TRUE,G2:H2)
copy down
That is fantastic! It works really well!
I appreciate you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks