Forum Discussion
Formatting Rows and Columns in Large Spreadsheet
I have a spreadsheet where Pledge IDs are displayed in Column A (thousands of rows), the the associated Pledge Payment IDs are on the same row, but extending for hundreds of columns. Here is an exam...
You may try the following formula-
=REDUCE({"Pledge ID","Payment ID"},TOCOL(DROP(A.:.A,1)&"|"&DROP(B.:.D,1),1),LAMBDA(a,x,VSTACK(a,TEXTSPLIT(x,"|"))))