This is going to save me days of editing data. Thank you so much! You are a genius to figure this out.

Man!!! You just saved me HOURS of work making 75 rows of each date for an entire year!! I've been searching the Internet for 2 days looking for this, thank you so much!! 🤘🤘

no bs.. only pure tutorial saves me a bunch of time, you my friend is a hero

Mind blowing! I can't tell you how many charts I've been copying and pasting data too. YOU'RE THE MAN! This is truly a game changer for me. I'm LIKING your page, I hope this helps your pocket.

You are a lifesaver! Searched the whole web for this easy fix. Thank you so much!!

31st January 2019, you saved me 3 days of work. Thank you my dear, simple but very effective and helpful

The first method worked perfectly for me, no formula, no macros, simple, quick. Thanks for this one, man!

Great approach, I love people who share their creativity with everyone

Very good technique, you're a lifesaver! FYI for everyone here in the comments, THIS DOES NOT WORK WITH ANY BLANK CELLS IN THE WORKBOOK!

@jamesball6069

2 жыл бұрын

For me, I was able to copy and paste the column into Word and delete all 0. Then bring back into Excel.

@jamesball6069

2 жыл бұрын

In Word ^p is a carriage return line feed so you use Ctrl-H. Find ^p^p and replace with ^p do this until all the excess carriage return line feeds are gone.

Very handy method. Especially using the shortcuts. Thanks for posting.

You are a genius for showing a simple method. Thank you.

This is BRILLIANT and saved me so much heartache! Thank you!

You do not understand how grateful I am for this, thanks so much

Amazing, this is exactly I was looking for, well let me try on my data, once again thanks a million

I was seriously expecting this video to be clickbait, but I'm pleasantly surprised, that was freakin' awesome dude!

My man have a sub because honestly you deserve it for such an easy fix to a lot of people's problems.

What an incredible process! Thank you for masterminding excel.

THANK YOU VERY MUCH. SIMPLE and WORKS PERFECTLY!

Absolutely amazing. thanks so much. saved me a loads of time

Thank you, man! You just saved me so much time!

What Victor Mello said!!! Worked really well. I had 1559 as my count number. Saved me hours

Thank you so, SO much for this incredibly helpful tutorial ! I have been trying to figure this out for WEEKS haha =D

Brilliant. The simple solutions are often the best.

Awesome! Really simple and effective. I still wonder if there is such a magic way to stack columns, but having the first column as the primary key, and then repeating them along the new stacked columns. Very useful when you have the KPI Titles in rows, and the periods are in the columns titles. It seems Excel works better when you have the opposite, with KPIs Titles leading the columns and then the Periods under a single "Period" Column. I believe Power BI has a "Unpivot" function that does that.

@tutorialsforeveryone1064

4 жыл бұрын

Sure, so the magic starting beneath column B instead of column A. Then, under the last cell of column A, reference the first cell of column A, and as you drag down column A, it will repeat the cells in column A again and again.

Mate this is magic hahaha Thanks for this! It potentially saved my team a lot of time!

You are a genius man. Absolute genius.

I just wish I had found this earlier... Very helpful, thank you!

This is how creativity combined with intelligence. Thank you!

MVPPPPPPP SAVED ME HOURS OF WORK!!!!!!!!!!!!!

Simple and very useful!

You are the best! Thanks from Argentina!!

Superb trick ! Really useful ! 👍🏼👍🏼

Thank you so much you just save a week time for me!!!!

Applied and work perfect, seriously thank you. :)

FANTASTIC SIMPLE AND EASY, THANKS A LOT

This is brilliant !!!

Thank you, you saved my day!

You are simply genius.....so simple and expertise less solution

Superb. Thanks a lot!

Thank you! This is amazing!!!

That is so cool. Thanks a lot, man.

Thank you man, thank you so much 👏

Very good method , saves a lot of time

super cool and very easy method, thanks so much for sharing!!!

Thank you for the help.

Excelent, thanks a lot for the help!

very useful skill，like from China👍

Very helpful video. Loved it

You're a legend !

tq so much....its saved my time...nice one...tq

This is pure love 💯

Very simple stupid method, easy to use, works perfect! Thnaks.

Nicely done!

Beautiful! Thank you so much!

Thanks for sharing this... It helped a lot!!!!!!!!!!!!!!!!!!!!!!!

Mate, you saved my life.. I thought I would had to fill 13K rows of values manually...

Thanks a lot for sharing this.

THANK YOU FOR SAVING ME HOURS OF PASTING COLUMNS

It works. Thank you very much for sharing this tip/

Thanks, it was really helpful.

Really helpful, thank you. Any way to reverse this? Go from one long column to multiple columns of X length?

Super like ! 👍

Thank you are a life saver

Thank you so much! Cleave. Just forgot about it

Very beautiful ❤️ this is very useful

This is great !!!!!!!! Thanks !!!

Hohohoh....amazing! I appreciate dear!

Thanks, that's helful and saves me lots of time

You have special genius genes!

Thanks a lot!

well done this worked great

Sir, could you please guide us to how to convert a long column into multiple columns for the printing purpose and how to find out missing number in a series in Excel

Thanks this is a game changer, Love the first method though

effective, efficient. well done

Thank you man!!

Thank You for this shortcut.

this is really genius way to do the job, never think any of this

love this!!!!!!!!!

Very helpful indeed

thanks a lot, indeed a great one

Perfect, thanks

Heroic!

Excellent solved my requirement

Thanks a lot, good one

This is amazing.....You are Saviour bro..... subscribed.

is there any excel settings that need to be set first? because i could follow until ctrl + R, but after i pressed ctrl + D, it didn’t appear like it should. It was only blank

@tutorialsforeveryone1064

2 жыл бұрын

There are no settings that need to be set first. Ctrl r simply fills from left to right within a highlighted range, ctrl d fills from top to bottom. If ctrl r or ctrl d is not working, then there probably was a glitch in one of the early steps, and the top or left most cell was not filled. To troubleshoot, before you hit ctrl r, check if the top left cell of the highlighted section has anything in it, if not you may have missed an earlier step, if yes, then there's some sort of issue that's beyond the scope of this tutorial.

Very useful. thanks

great video

Thank you so much.

you saved my thesis

Thank u friend,

Superb

@duraitvm

4 жыл бұрын

GOOD

Super Genius!!

I wonder if this way multi columns values can be listed in one then same SKU (Values duplication and single to be counted for an inventory purpose please help, Thanks

@tutorialsforeveryone1064

Жыл бұрын

You can do this, and then do a COUNTIF in the next column to count duplicates. You can then do remove duplicates to remove the duplicates (search Google for COUNTIF and Remove Duplicates if you're not familiar)

Thank you for this! I have a slight twist. Is it possible to have the columns return in column order? There will be no way for me to sort the data once it is populated under the last row and it must be placed in column order.

@tutorialsforeveryone1064

5 жыл бұрын

The data populates under the first column in the order of the columns. (Column 1, underneath that column 2, etc) Please clarify how you want it to sort, and I'll let you know if I have a way.

@Serraomomma

5 жыл бұрын

Can I post a pic?

@tutorialsforeveryone1064

5 жыл бұрын

@@Serraomomma sure

Thank you So much

perfect!!! رائع!!!

thanks so much

very good trick.

BRAVO!