Thank you so so much! Your guides in this video helped me so much in how to create a task management system in a most effective way to me. I can't thank you enough. And if you ever come to Nha Trang, Vietnam please let me know, I'd love to thank you in person. Sending you my appreciation vibes from Nha Trang on Sunday, 18 April, 2021. Thanks again very much!
Thanks a lot for that informative Lesson. However, i have one question plz i tried to implement filer & len to combine data from two colmns from two different sheets but once i wrote { errors started to Shown... may u explain how to merge data from two columns in different sheets plz...thanks again
Hey Moustafa! Here are a few examples: Combining columns A and B from one sheet, into another sheet: =filter({Sheet1!A3:A12;Sheet1!B3:B12},len({Sheet1!A3:A12;Sheet1!B3:B12})) Combining column A from one sheet, with column B from a second sheet, into a third sheet: =filter({Sheet1!A3:A12;Sheet2!B3:B12},len({Sheet1!A3:A12;Sheet2!B3:B12})) Combining both columns A and B from two sheets, into a third sheet: =filter({Sheet1!A3:A12;Sheet1!B3:B12;Sheet2!A3:A12;Sheet2!B3:B12},len({Sheet1!A3:A12;Sheet1!B3:B12;Sheet2!A3:A12;Sheet2!B3:B12}))
Thank you for your video! Is there any way to compare more than 2 columns? I have 4 columns in which numbers should match. If all four numbers are equal, it's true otherwise (if at least 1 out of 4 do not match) is false. Ideally to make it with conditional formatting to color in green if true and in red if false.
Glad you liked the video! If you're comparing more than 2 columns, you can use the IF function combined with the AND function to do something like this: =if(and(A2=B2,B2=C2,C2=D2),"Match","No Match") If you're comparing 2 columns you can do this =A2=B2 and it will yield true / false
here is my long list of columns Im trying to combine into one column ={A1:A25;B1:B25;C1:C25;D1:D25;E1:E25;F1:F25;G1:G25;H1:H25;I1:I25;J1:J25;K1:K25;L1:L25;M1:M25;N1:N25;O1:O25;P1:P25;Q1:Q25;R1:R25;S1:S25;T1:T25;U1:U25;V1:V25;W1:W25}
@@spreadsheetclass Hi Ive got a question on this. would I be able to combine columns like this: =FILTER({Form_responses!E2:E;F2:F;G2:G;H2:H;I2:I;J2:J;M2:M}, len({Form_responses!E2:E;F2:F;G2:G;H2:H;I2:I;J2:J;M2:M})). Notice that the upper limits of the columns just indicate the column letter and not something like E2:E12. Would this still work?
Wondering if you could help me, I want to separate my sheet into 2 sections, just like how your Uncombined Data and Combined Data are. Say I want to be able to make adjustments to Uncombined Data without applying the changes to Combined Data, for instance dragging the "2" row down to be a larger size. Can this be done? Thank you!
Hey Roy, I didn't quite understand what you were trying to do, especially when you mentioned " dragging the "2" row down to be a larger size". Can you give me some more detail and I'll try to solve it!
You can with a formula like this: =UNIQUE({A3:A12;B3:B12;"Text"}) Otherwise you can put the text into another column, and stack that column with the others.
Hello, can you help me? I used your forumla once and it worked after refreshing. Tried it again, and I get an error code about circular dependency. I've triple checked the formula and all looks correct.
How do I make my spreadsheet look like the "Uncombined Data" section? I already inputted all my information, but realized it would look better with two columns under one, but I can't for the life of me figure it out.
This is done by merging two cells together at the top of two columns (Such as merging cells A1 and B1), then you'll have two columns below a single heading. The "Merge" feature is on the top toolbar.
@@spreadsheetclass docs.google.com/spreadsheets/d/1mxjK0Cu5E7V1kaXVpN4KSqEdvd6f_hnq1LJ2RN8KLNY/edit?usp=drivesdk , that is the example of the problem man
You should be able to stack the columns as long as they are the same size. I have stacked many different columns together using some of the methods in the videos. Example: ={A3:A12;B3:B12;C3:C12;D3:D12}
Thanks so much! This formula saved me a lot of tedious work!
That's awesome, I am always happy to hear that the lessons are helping others:)
Thank you so so much! Your guides in this video helped me so much in how to create a task management system in a most effective way to me. I can't thank you enough. And if you ever come to Nha Trang, Vietnam please let me know, I'd love to thank you in person. Sending you my appreciation vibes from Nha Trang on Sunday, 18 April, 2021. Thanks again very much!
I am VERY happy that the video helped you!!! I hope that you have an amazing day!
Great explanation. Thanks and keep up the good work. You explain really well.
Thanks Kenneth, I really appreciate that! Glad you enjoyed the video.
Wow thank you! This solved my task😊😊
I am glad that it helped!
Much appreciated. Exactly what I was looking for! Thank You!
Absolutely, I am glad to help!
This helped me! Thanks for the video
That's awesome, I am glad it helped!!
great solution
Glad that you enjoyed it Mohd!
Wonderful & concise tutorial!
Thanks Atul, glad you enjoyed it!
THANK YOU!!!
Absolutely!
great article
Thank you Stephen, I am glad you liked it!
Thanx a ton now I just need to figure a way to select, copy and paste the combined column.
Thank you so much for this.
Absolutely! Glad that it helped.
thank you so much, it's really helping..!
Absolutely! Glad to help.
wonderful❤❤❤❤❤❤
Glad you enjoyed it!!!
Thanks a lot for that informative Lesson. However, i have one question plz i tried to implement filer & len to combine data from two colmns from two different sheets but once i wrote { errors started to Shown... may u explain how to merge data from two columns in different sheets plz...thanks again
Hey Moustafa! Here are a few examples:
Combining columns A and B from one sheet, into another sheet:
=filter({Sheet1!A3:A12;Sheet1!B3:B12},len({Sheet1!A3:A12;Sheet1!B3:B12}))
Combining column A from one sheet, with column B from a second sheet, into a third sheet:
=filter({Sheet1!A3:A12;Sheet2!B3:B12},len({Sheet1!A3:A12;Sheet2!B3:B12}))
Combining both columns A and B from two sheets, into a third sheet:
=filter({Sheet1!A3:A12;Sheet1!B3:B12;Sheet2!A3:A12;Sheet2!B3:B12},len({Sheet1!A3:A12;Sheet1!B3:B12;Sheet2!A3:A12;Sheet2!B3:B12}))
@@spreadsheetclass Many Thanks for immediate response. is that applicable for regular excel 365 or only for google sheets?
My apologize i forgot to mention that i am using excel 365 not google sheets, so what is the change could be done here in your formula
Thank you for your video! Is there any way to compare more than 2 columns? I have 4 columns in which numbers should match. If all four numbers are equal, it's true otherwise (if at least 1 out of 4 do not match) is false. Ideally to make it with conditional formatting to color in green if true and in red if false.
Glad you liked the video! If you're comparing more than 2 columns, you can use the IF function combined with the AND function to do something like this: =if(and(A2=B2,B2=C2,C2=D2),"Match","No Match")
If you're comparing 2 columns you can do this =A2=B2 and it will yield true / false
@@spreadsheetclass thank you for your answer! I'll try it for my table!
Thanks a lot!
Absolutely!
here is my long list of columns Im trying to combine into one column ={A1:A25;B1:B25;C1:C25;D1:D25;E1:E25;F1:F25;G1:G25;H1:H25;I1:I25;J1:J25;K1:K25;L1:L25;M1:M25;N1:N25;O1:O25;P1:P25;Q1:Q25;R1:R25;S1:S25;T1:T25;U1:U25;V1:V25;W1:W25}
Did it work? You should be able to stack as many as you need if the columns are the same size.
@@spreadsheetclass Hi Ive got a question on this. would I be able to combine columns like this: =FILTER({Form_responses!E2:E;F2:F;G2:G;H2:H;I2:I;J2:J;M2:M}, len({Form_responses!E2:E;F2:F;G2:G;H2:H;I2:I;J2:J;M2:M})). Notice that the upper limits of the columns just indicate the column letter and not something like E2:E12. Would this still work?
Wondering if you could help me, I want to separate my sheet into 2 sections, just like how your Uncombined Data and Combined Data are. Say I want to be able to make adjustments to Uncombined Data without applying the changes to Combined Data, for instance dragging the "2" row down to be a larger size. Can this be done? Thank you!
Hey Roy, I didn't quite understand what you were trying to do, especially when you mentioned " dragging the "2" row down to be a larger size". Can you give me some more detail and I'll try to solve it!
In the stacked array, can I add additional text when stacked?
You can with a formula like this: =UNIQUE({A3:A12;B3:B12;"Text"})
Otherwise you can put the text into another column, and stack that column with the others.
Hello, can you help me? I used your forumla once and it worked after refreshing. Tried it again, and I get an error code about circular dependency. I've triple checked the formula and all looks correct.
Hi Lorraine, can you give me some more details about your exact formula? Or did you already figure this one out?
How do I make my spreadsheet look like the "Uncombined Data" section? I already inputted all my information, but realized it would look better with two columns under one, but I can't for the life of me figure it out.
This is done by merging two cells together at the top of two columns (Such as merging cells A1 and B1), then you'll have two columns below a single heading. The "Merge" feature is on the top toolbar.
Hey man, how do i combine randomly separated columns with the same pivot/header column names into one column, it's actually the gform problem
I didn't quite understand that, can you give me some more detail?
@@spreadsheetclass docs.google.com/spreadsheets/d/1mxjK0Cu5E7V1kaXVpN4KSqEdvd6f_hnq1LJ2RN8KLNY/edit?usp=drivesdk , that is the example of the problem man
this is good but not helpful for stacking more than 3 columns. I need to stack about 30 into one.
You should be able to stack the columns as long as they are the same size. I have stacked many different columns together using some of the methods in the videos. Example: ={A3:A12;B3:B12;C3:C12;D3:D12}