CONCATENATE BIO, CLOTHING SIZE, SHOE SIZE, WISH LIST ETC. IN 1 CELL PER APPLICANT

[COGICPENNY]

HELP TEST SUPPORT

Sheet1 FAMILY ID NO.,Timestamp,PROCESSED BY,APPROVED/DECLINED DATE,DATA REFRESH DATE,DATA REFRESH STATUS (LISTED, ADOPTED),SHOPIFY POSTING,ADOPTION BIO,ADOPTION DATE,REJECTION DATE,REJECTION REASON,Donor Confirmation,Email,DONOR NAME,DONOR EMAIL,DONOR PHONE,Donor Street Address,Donor City, State...

docs.google.com

I need to create a formula that will populate the field i will use (column h). When done correctly, it will look like this (with corresponding cell content):

Referral type:
Family background:

Adult #1
Age:
Gender:
Clothing size:
Shoe size:
Wish list:

Adult #2:
Age:
Gender:
Clothing size:
Shoe size:
Wish list:

Individual #1:
Age:
Gender:
Clothing size:
Shoe size:
Wish list:

Individual #2:
Age:
Gender:
Clothing size:
Shoe size:
Wish list:

Individual #3:
Age:
Gender:
Clothing size:
Shoe size:
Wish list:

Individual #4:
Age:
Gender:
Clothing size:
Shoe size:
Wish list:

Individual #5:
Age:
Gender:
Clothing size:
Shoe size:
Wish list:

Individual #6:
Age:
Gender:
Clothing size:
Shoe size:
Wish list:

The headers i wrote above are mandatory for each applicant (i.e. Referral type, family background, etc.). I had a stroke, paralyzed on my right, and it's too difficult for me to do. For years my non-profit adopts families for christmas. They sign up, and i combine all the necessary information on our internet portal, so that people in the community can adopt them for the holidays. Your assistance is greatly appreciated. Hopefully it is self-explanatory. Penny

 

[COGICPENNY]

I FOUND OUT I CAN PROVIDE THE LINK TO THE REAL FILE. IT IS POSTED BELOW. SORRY ABOUT THAT.

Operation Holiday® 2023 Application 11222023 (Responses)

 

[Peter_SSs]

Reminder:
Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Long formula to create attached applicant profile for our program
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

While visiting the rules, please also review #14 regarding using all upper case in your thread title.