M missterry Eternal Poster Joined Jun 7, 2020 Posts 1,147 Solutions 2 Reaction 333 Points 361 Jan 14, 2023 #1 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. Attachments You do not have permission to view the full content of this post. Log in or register now.
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.
M micsol80 Enthusiast Jan 14, 2023 #2 =A2&","&B2&" "&C2&" "&D2 micsol80 said: =A2&","&B2&" "&C2&" "&D2 Click to expand... Attachments You do not have permission to view the full content of this post. Log in or register now.
F fireclouu Honorary Poster Jan 14, 2023 #3 assuming nasa row 'A' yung start ng Last Name =A2 & ", " & B2 & " " & C2 Click to expand... edit: mali yung cell heheh
assuming nasa row 'A' yung start ng Last Name =A2 & ", " & B2 & " " & C2 Click to expand... edit: mali yung cell heheh
D dayzero Addict Jan 15, 2023 #4 Magkakasunod ba dapat sa pangalawa sheet parang ganto? Attachments You do not have permission to view the full content of this post. Log in or register now.
M missterry Eternal Poster Jan 15, 2023 TS TS #5 dayzero said: Magkakasunod ba dapat sa pangalawa sheet parang ganto? View attachment 2465532 Click to expand... yes po micsol80 said: =A2&","&B2&" "&C2&" "&D2 View attachment 2464932 Click to expand... fireclouu said: assuming nasa row 'A' yung start ng Last Name edit: mali yung cell heheh Click to expand... Thank you po sa help!! ) micsol80 said: =A2&","&B2&" "&C2&" "&D2 View attachment 2464932 Click to expand... Pano ho pag yung strand at section ay sa next row po ng names like yung sa pic ko po sa itaas? Thank you! Last edited: Jan 15, 2023
dayzero said: Magkakasunod ba dapat sa pangalawa sheet parang ganto? View attachment 2465532 Click to expand... yes po micsol80 said: =A2&","&B2&" "&C2&" "&D2 View attachment 2464932 Click to expand... fireclouu said: assuming nasa row 'A' yung start ng Last Name edit: mali yung cell heheh Click to expand... Thank you po sa help!! ) micsol80 said: =A2&","&B2&" "&C2&" "&D2 View attachment 2464932 Click to expand... Pano ho pag yung strand at section ay sa next row po ng names like yung sa pic ko po sa itaas? Thank you!
D dayzero Addict Jan 16, 2023 #6 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. Attachments You do not have permission to view the full content of this post. Log in or register now.
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.