Hi, I can help you with your question. Can you attach a sample of the excel file you are creating? That way I can make edits directly to the file and you can copy and paste.
concatenate is the string command you are looking for to join text, or text from cells together into one string
I have created a small example that answers both of your questions, in a very general sense. If you can attach your file, with one or two of the columns filled in, and then tell me where you want the functions to go I can get you an answer specific to what you need and explain it to you. It would probably help you to understand the functions better.
I saw that you reviewed this answer a few days ago, please let me know how I can improve my answer to be of better use to you.