No video :(

Excel: move every other row to a new column

Подписаться 74 тыс.

Просмотров 42 тыс.

50% 1

Need to move every other row in Excel to another column? It is easy to do with the ISODD or ISEVEN function. In this video, I use ISODD / ISEVEN with IF and the ROW function. Finally, in this video, I filter the data and remove the blanks.
Chapters:
0:00 Intro
1:20 Row function
1:50 ISODD/ISEVEN
2:34 Row Function to number list
4:30 IF/ISODD/ROW
6:20 Delete - shift up
6:50 Filter to delete blank rows
Row Function
The Row function identifies what row you are working in. =ROW() returns 2 if you are in row 2. =ROW() returns 7 if you are in row 7. =ROW(120) returns 120 if you are in row 120. =ROW(4)-1 returns
3 if you are in row 4. It takes 4 and subtracts 1.
ISODD Function
The ISODD function returns true or false. An odd number is TRUE and an even number is FALSE. =ISODD(7) returns TRUE. =ISODD(14) returns FALSE.
ISEVEN Function
The ISEVEN returns true or false. An even number is TRUE and an odd number is FALSE. =ISEVEN(7) returns FALSE. ISEVEN(14) returns TRUE.
The file used in this video:
chrismenardtra...
#excel #microsofexcel #exceltips
Chris Menard's website: chrismenardtra...
Cristian's RU-vid Channel: / @graphicious
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera - amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod - amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera - amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording - Camtasia - chrismenardtra...
○ Screenshots - Snagit - chrismenardtra...
○ RU-vid keyword search - TubeBuddy - www.tubebuddy....
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

Опубликовано:

18 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 124

@mwendabaimwendabai4923 3 месяца назад

I am going to bookmark this forever! You have no idea how I was cratching my head and trying to figure out what I need to do to get this done. I love it!

@tammychoink8617 3 года назад

Exactly what I wanted - no waffle and straight to the answer whilst explaining the steps. Superb.

@ChrisMenardTraining 3 года назад

Thank you.

@Nabiyah1 2 месяца назад

Straight Forward. Clear. Great Visual and Audio Instructions. Saved me a TON of Time! Thank You Brotha! Excellent Video. New Sub!

@johnmcneeley5880 5 месяцев назад

This was exactly what I needed. I had data with associated entries stacked on top of eachother because it was a dead pull from two different systems. I was able to get things all lined up exactly how I needed. Thank you for clearly writing this out and giving a solid explanation of what everything is doing. Glad it all still works three years later.

@ChrisMenardTraining 5 месяцев назад

Thank you. I'm glad it is still working also. :-)

@nickoftime7535 Год назад

Thank you! Using your video, I was able to modify it and figured out a way to complete a task at work in 30 minutes rather than 4 hours.

@gabrielkimbrough 10 месяцев назад

This is awesome. Worked great for a list of 4000 companies and addresses. Thank you!!

@ChrisMenardTraining 10 месяцев назад

That is awesome! Thanks for letting me know it worked.

@lockoutslayer 3 года назад

This man is a genius. . . Exactly what I needed. Felt like you could read my mind.

@ChrisMenardTraining 3 года назад

Thank you! I'm not sure about genius, but I appreciate the comment. :-)

@shieldteam 4 месяца назад

Thank you! Easy to follow and worked perfectly

@IuliusCaesar18 2 года назад

Thanks a lot, Chris! You saved me a lof of time and headache, couldn't ask for a better Excel tutorial!

@ChrisMenardTraining 2 года назад

You're welcome! Thanks, Caesar11.

@user-wk1ne9qw3r Год назад

Perfect explanation! Thank you.

@ChrisMenardTraining Год назад

You bet. Thanks, Stephen.

@craiggoebbel8922 2 года назад

I love learning new things. This is exactly what I needed. Thank you.

@harshkatyal8470 Год назад

Thanks...came in handy at just the right time

@ChrisMenardTraining Год назад

Glad to help. Thanks, Harsh,

@Suriel08 Год назад

Thanks for this! Great explanation.

@ChrisMenardTraining Год назад

You are welcome. Thanks for visiting.

@thepgprincess 2 года назад

Just saved my life...subscribed.

@ChrisMenardTraining 2 года назад

Thanks, Monique!

@NicholeCIEE 7 месяцев назад

Thank you so much for this video and your extra explanations about each function! Perfect for what I'm working on today and will also help in the future.

@nicolef9165 7 месяцев назад

This was so helpful and a great intro to IF and IS statments in excel. I really appreciate this!

@bronfoth 2 года назад

Thanks for a great explanation. Fabulous teaching. The row tip for numbering is much appreciated too!

@ChrisMenardTraining 2 года назад

You're very welcome!

@bronfoth 2 года назад

@@ChrisMenardTraining it worked well. I ended copying the "values only" onto a new Sheet in correct alignment, and then filtering/deleting the blank cells. With almost 3000 rows in each of my 2 columns so this was WONDERFUL!

@olehchuprynskyi4599 Год назад

Thank you a lot! This video lesson has saved me a ton of time! Super helpful!!!

@ChrisMenardTraining Год назад

I appreciate the positive feedback. Thank you.

@wanderer4196 11 месяцев назад

What I was exactly looking for. Thanks for keeping it simple :) Absolutely brilliant!

@ChrisMenardTraining 11 месяцев назад

You're welcome!

@cheuky555 Год назад

thanks so much, your method is way easier compared to other youtube videos ive seen

@ChrisMenardTraining Год назад

Glad to hear that!

@davidh2260 10 месяцев назад

Perfect Chris, just what I needed for a quick task. Not only did it do what I needed, similar to the example but it is very flexible and efficient so I will keep a note the method for other use cases. Great teaching style and yep, now another subscriber! Thank you 😀

@maggiemondo7459 2 года назад

Absolutely brilliant. This is just what I need for an excel task today. Thank you.😀

@ChrisMenardTraining 2 года назад

You're very welcome!

@MrPaddy35 Год назад

Exactly what i was looking for :) Thank You :)

@ChrisMenardTraining Год назад

Glad I could help!

@nic5958 Год назад

This is amazing! Wonderful tutorial. Thank you so much. You saved me like three hours

@ChrisMenardTraining Год назад

You're welcome!

@penguin0075 Год назад

Hello from the UK! Brilliant video Chris, thank you so much as I need this for a task at work. I have client lists and next of kin contact details for each client are on every other row, I will test this tomorrow as I think think this will work perfectly for moving the data from every other second row, to the first row. Thanks so much! Subscribed too ☺️

@ChrisMenardTraining Год назад

Fantastic! Thank you.

@TomIkonomouVancouverHomes 2 года назад

Thank you Sir. Very well produced and easy to understand.

@ChrisMenardTraining 2 года назад

You are very welcome. Thanks, Tom.

@AlekyaPawarMamidi Год назад

Thank you, you helped a lot with my sheet :)

@ChrisMenardTraining Год назад

Thank you.

@nj678 10 месяцев назад

So Helpful. Thank you for the clear steps and easy to understand:) 🙂

@savissm Год назад

Thank you so very much, very clear and easy to follow, Thank you !

@ChrisMenardTraining Год назад

You're very welcome!

@flemmingelmstrand3061 Год назад

Didn't work for me first, but then I realized that when you hit comma, I have to use Semikolon....But you saved my day (had a list with +1.000 entries I had to get sorted) THANKS A LOT

@ChrisMenardTraining Год назад

Thank you! That one keyboard key can get you. :-) I'm glad you got it to work.

@PeggyStinson Год назад

@@ChrisMenardTraining wait, where do I need to use a semicolon...I'm in Europe. because this does not work for me - does this work for Excel 365?

@PeggyStinson Год назад

oh wow - this is what I used - =WENN(ISTUNGERADE(ZEILE());A1;"") and it worked. (using a German version of Excel)

@chriscowboyfan 5 месяцев назад

WOW !!! I didnt know if this could be done. Thank you so much helped me out alot

@ChrisMenardTraining 4 месяца назад

You're welcome!!

@greensandgolds 10 месяцев назад

great - thank you so much, very easy to follow and exactly what I needed. Will be subscribing.

@ChrisMenardTraining 10 месяцев назад

Awesome, thank you!

@JaKoMaGrp 3 года назад

Thank you Chris, this is awesome! Saved me hours of work!!

@ChrisMenardTraining 3 года назад

You're welcome!

@willennavarra5556 2 года назад

I am having a hard time looking for the correct formula for my today's task. This video of yours helped me a lot :) Thanks!

@ChrisMenardTraining 2 года назад

Excellent! Thanks, Willen .

@bhaveshmunot136 2 года назад

It's just amazing....you taught so calm ....🎉🔥

@ChrisMenardTraining 2 года назад

Thank you so much 😀

@dido.the.side.h0646 2 года назад

This was so so helpful thanks! very clearly explained

@AmaruCH 2 года назад

Helpful indeed! Thank you. You save me a bunch of time.

@ChrisMenardTraining 2 года назад

You're welcome!

@yashvardhanpandey4523 2 года назад

magic wow i was searching for this but i didn't know how to search for this haha many thanks dude , big help

@ShannCommand Год назад

YOU ARE AMAZING! Thank you so much!

@mbe2533 2 года назад

Thank you, Chris! This worked perfectly! You saved me lots of time.

@ChrisMenardTraining 2 года назад

Glad it helped!

@MrBos2000 2 года назад

Exactly what I need. You are awesome. Thanks a lot for this help. I have subscribe to your channel. Keep making such helpful contents

@ChrisMenardTraining 2 года назад

Thank you, Mohan! I appreciate the sub!

@razminazman7323 2 года назад

Chris thank you so much. Trully appreciate this video.

@ChrisMenardTraining 2 года назад

My pleasure!

@jazminemiddleton9775 2 года назад

This really saved me! Thank you so much!!!!!!!!!!!!!!

@ChrisMenardTraining 2 года назад

Jazmine, glad to help.

@hanrealistic Год назад

excellent tutorial

@ChrisMenardTraining Год назад

Thank you.

@hannahpetersen1134 2 года назад

Helps a lot. btw in my excel IF function uses ; instead of ,

@ChrisMenardTraining 2 года назад

That sounds like a Windows setting, but as long as it is working, that's all that matters. :-)

@melaniepaquiyauri9444 Год назад

Thank you so much, Chris! You are a life saver :)

@flowgurus 3 года назад

Absolute life saver. Pure gold thank you :)

@ChrisMenardTraining 3 года назад

Thank you!

@iRocGrl Год назад

Thank you so much and so clearly explained!

@shauntairenee1270 3 года назад

Such a great help! Worked like a charm!

@ChrisMenardTraining 3 года назад

Thank you!

@ilanalani 3 месяца назад

Thank you so much!

@ChrisMenardTraining 3 месяца назад

You're welcome!

@the_blurbob2556 2 года назад

Hey Chris, I have a problem, I seem to not be able to use the function and Excel keeps popping up the message "there's a problem with this formula" (but in Spanish, I use it in Spanish because it's my main language). it keeps on saying that I'm not trying to use a formula and to rewrite the formula for it to just output text what do I do?? i really need to separate even and odd values but doing it by hand would be incredibly tedious and hard... Also, I use mac if that of any importance. Thanks for any help you can provide

@user-zb6st2hi8c 5 месяцев назад

Great information, which I'm sure will come handy in the future. How can I transfer data from Column B into Column A, If I have 100 part numbers in Column A and I need to insert a serial number from column B into Colum A after every other cell? For example, the Serial number has to be inserted below it's Part number, not across in row B.

@jingle3 8 месяцев назад

Thanks Chris!

@74H1D 8 месяцев назад

thank you, my dear

@ChrisMenardTraining 8 месяцев назад

Welcome 😊

@gesaputra 6 месяцев назад

Thanks man. Auto subscribed

@jordanbaker931 2 года назад

Very helpful, thanks!

@ChrisMenardTraining 2 года назад

You're welcome!

@A7medChannel 2 года назад

Thank you

@ChrisMenardTraining 2 года назад

You're welcome

@asingh386 2 года назад

Thank you!!!

@ChrisMenardTraining 2 года назад

You're welcome!

@lihuazeng7640 Год назад

wow! thank you!

@ChrisMenardTraining Год назад

welcome.

@renbaldwin4024 3 года назад

Excellently done. You refer to chapters. Where are those chapters to be found?

@ChrisMenardTraining 3 года назад

Those are the bookmarks throughout the video. The blue dots with the timestamps. drive.google.com/file/d/1I5AM-SVzK-WvtQD3Vdxkf5hplUOLjjv3/view?usp=drivesdk

@Nabiyah1 2 месяца назад

Thanks!

@Thanasis_Tsiris 9 месяцев назад

Very nice! What if I want to copy every 5th row?

@jonathansamuel1223 2 года назад

with excel (16.0.14326) - values is separted by ';" instead of "," so the command is =IF(ISODD(ROW());A2;"")

@martindobrovic2223 3 года назад

Thank you. Awesome.

@ChrisMenardTraining 3 года назад

You bet!

@danf73 2 года назад

Awesome! + new subscriber

@ChrisMenardTraining 2 года назад

Thanks for subbing!

@FromHawaii83 3 года назад

Good tip but for me (Mac) every time I click "delete row" (after applying the filter) the filter is no longer selected and ALL my highlighted rows are gone. Have you run across this before? Any tips? tnx

@SeanMomeny 3 года назад

That was great. Thnx

@ChrisMenardTraining 3 года назад

You're welcome!

@belzebul 2 года назад

6:17 and 7:11 How do I select all items, if let's say, my data is not in 5 rows, but there is 500 rows of data? Thank you

@traceyagate9578 2 года назад

amazing :)

@ChrisMenardTraining 2 года назад

Thank you.

@mharnish Год назад

What if the original data in Column A spans 3 rows E.g., Row 1 = "Delta Airlines", Row 2 = "11 Main Ave. Atlanta GA 30303" and Row 3 = "800 123 4567". Is there a formula to move data from Rows 2 and 3 to Columns B and C respectively?