🔒 Closed Excel experts, I badly need your helpp

[missterry]

Hello mga ka-PHC! Badly needed your help right now po in regards to excel.

I have these data right here:

and I want them to be transformed into like this all at once without typing them one by one.

Is that possible? If so, how should I do it. Thank you in advance!

P.S. Those two pics attached above is from 2 different sheets.

 

[micsol80]

=A2&","&B2&" "&C2&" "&D2

=A2&","&B2&" "&C2&" "&D2

 

[fireclouu]

assuming nasa row 'A' yung start ng Last Name

=A2 & ", " & B2 & " " & C2

edit: mali yung cell heheh

 

[dayzero]

Magkakasunod ba dapat sa pangalawa sheet parang ganto?

 

[missterry]

Magkakasunod ba dapat sa pangalawa sheet parang ganto?

View attachment 2465532

yes po

=A2&","&B2&" "&C2&" "&D2


View attachment 2464932

assuming nasa row 'A' yung start ng Last Name




edit: mali yung cell heheh

Thank you po sa help!! )

=A2&","&B2&" "&C2&" "&D2


View attachment 2464932

Pano ho pag yung strand at section ay sa next row po ng names like yung sa pic ko po sa itaas? Thank you!

 

[dayzero]

if yun name ng first sheet is Sheet1 sa full name field nya

=UPPER(OFFSET(Sheet1!$A$1,ROUNDDOWN((ROW(Sheet1!A1)-1)/2,0)+1,0)&", "&OFFSET(Sheet1!$B$1,ROUNDDOWN((ROW(Sheet1!A1)-1)/2,0)+1,0)&" "&OFFSET(Sheet1!$C$1,ROUNDDOWN((ROW(Sheet1!A1)-1)/2,0)+1,0))

then sa section part naman

=UPPER("STRAND / "&OFFSET(Sheet1!$D$1,ROUNDDOWN((ROW(Sheet1!A1)-1)/2,0)+1,0))

basically yun UPPER function para macapitalize then gumamit naman ng OFFSET function dahil may interval yun row ng full name sa Sheet2 and yung ROUNDDOWN naman para sa parameter ng offset function kung ilan interval which is nadivide by 2.