Forum Discussion
Individuals Content in rows to two columns
I need to pull only names and emails from these rows (each person has 25 rows) and transverse them into two columns to just have the name and emails listed. Any ideas?
=(HSTACK(CHOOSECOLS(FILTER(A1:B28,A1:A28="Name"),2),CHOOSECOLS(FILTER(A1:B28,A1:A28="Email"),2)))See attached workbook as demo.
