Hi, thanks a lot! :D Not only one, but 2 methods for solving this!! :D Also, I wanted to warn people that 2nd method didn't work for me until I realized that I needed to replace the commas with semicolons (maybe because I'm in Spain and formulas have different sintaxis here? I'm not sure), so if somebody has the same issue, just use these instead: Formula in column G =FILTER(A1:A; MOD(ROW(A1:A)+2; 3)=0) Formula in column H =FILTER(A1:A; MOD(ROW(A1:A)+1 ;3)=0) Formula in column I =FILTER(A1:A; MOD(ROW(A1:A); 3)=0)
Thanks for the comment. I saved it until I had time to look into it. It wouldn't work if you just swapped the columns with the rows because that would make one long row. Are you sure TRANSPOSE would work?
Love all you videos! Is there a way to keep that "=A2, =A3, =A4" pattern going indefinitely? I am trying to do the opposite than this video, and stack multiple columns into one column. My project= I have a string of 10-30 names and phone numbers from a google form input all in one row. I have used the TRANSPOSE function to change it from 1 row to multiple columns- now I just want to stack them. Any tips? =) Also: If using the patter "=A2, =A3, =A4" like you did above, I made this that woked for me but can not figure out how to make it continue indefinitely. *a2 *b2 *c2 *d2 *e2 *f2 *g2 *h2 *i2 *j2 *k2 *l2 *m2*n2 *o2 *p2 *q2 *r2 *s2 *t2 *u2 *v2 *w2 *x2 *y2 *z2 *aa2*ab2*ac2*ad2... all the way to *Et2
What happens if you select all of the cells with contents, go to the lower right hand corner of the box, left-click, and drag down. It doesn't auto fill?
Any suggestion? When I click "done" after edit replacing "FILLERA1" etc, all my beautiful columns of information which are seen (as desired) turn back into a formula (example =A1,=A2 etc) how do I get the information for that table to stay there and not turn into another formula? thanks.
Prolific Oaktree thank you for replying. I am currently working in a new field and Excel is very important to my job and I really need some help with excel.
Hi, thanks a lot! :D Not only one, but 2 methods for solving this!! :D
Also, I wanted to warn people that 2nd method didn't work for me until I realized that I needed to replace the commas with semicolons (maybe because I'm in Spain and formulas have different sintaxis here? I'm not sure), so if somebody has the same issue, just use these instead:
Formula in column G
=FILTER(A1:A; MOD(ROW(A1:A)+2; 3)=0)
Formula in column H
=FILTER(A1:A; MOD(ROW(A1:A)+1 ;3)=0)
Formula in column I
=FILTER(A1:A; MOD(ROW(A1:A); 3)=0)
Incredibly helpful info and you even have the formulas in the description - earned my sub! Thank you very much!
Awesome, thank you!
Thanks so much for this. A great help in addressing this exact issue across 40+ different data sheets
BRILLIANT. Saved me so much time.
Very helpful thank you!
Thank you very much!
Thank you so much!
Thanks!
Hey you could use the Transpose Function. It deals with Arrays :)
Thanks for the comment. I saved it until I had time to look into it. It wouldn't work if you just swapped the columns with the rows because that would make one long row. Are you sure TRANSPOSE would work?
YES FINALLY I FOUND IT
Brilliant idea
Thanks a lot!
Love all you videos! Is there a way to keep that "=A2, =A3, =A4" pattern going indefinitely?
I am trying to do the opposite than this video, and stack multiple columns into one column.
My project= I have a string of 10-30 names and phone numbers from a google form input all in one row. I have used the TRANSPOSE function to change it from 1 row to multiple columns- now I just want to stack them. Any tips? =)
Also: If using the patter "=A2, =A3, =A4" like you did above, I made this that woked for me but can not figure out how to make it continue indefinitely.
*a2 *b2 *c2 *d2 *e2
*f2 *g2 *h2 *i2 *j2
*k2 *l2 *m2*n2 *o2
*p2 *q2 *r2 *s2 *t2
*u2 *v2 *w2 *x2 *y2
*z2 *aa2*ab2*ac2*ad2...
all the way to *Et2
What happens if you select all of the cells with contents, go to the lower right hand corner of the box, left-click, and drag down. It doesn't auto fill?
Any suggestion? When I click "done" after edit replacing "FILLERA1" etc, all my beautiful columns of information which are seen (as desired) turn back into a formula (example =A1,=A2 etc) how do I get the information for that table to stay there and not turn into another formula? thanks.
Try the key combination Ctrl + ` (grave accent)
Hi Sir, I reaching out to you to ask whether you offer online courses in Excel?
Thanks for asking. I have not made an Excel courses. Some videos, but not courses.
Prolific Oaktree thank you for replying. I am currently working in a new field and Excel is very important to my job and I really need some help with excel.
Well, here’s the best Excel video that I made. th-cam.com/video/NhtyFiBzQDk/w-d-xo.html
Prolific Oaktree thank you Sir.