I'm really happy that I've subscribed to this channel. I'm going to look like a star.
@excelisfun
7 жыл бұрын
You definitely WILL be a star!!! I bet you are already a star!!!! Thank you for your Sub and Thumbs Up on each video : )
@Tracks777
7 жыл бұрын
Keep it up! Looking forward for more videos from you, don't stop!
@excelisfun
7 жыл бұрын
You are welcome! Many, many more to come!!! Thanks for your Sub and Thumbs Up on each video : )
@johnborg5419
5 жыл бұрын
Tricks like these is what keeps me going!!! Thanks
@excelisfun
5 жыл бұрын
Me too, Teammate! Isn't it fun : )
@MartinHoydal
Жыл бұрын
Thanks, wonderful with the "ctrl-c-c"-trick in the start. I only needed to do this once, and not in need of having a script for later. Thanks!
@excelisfun
Жыл бұрын
You are welcome!
@PramodChauhan
2 жыл бұрын
Thanks, It's really very good formula
@excelisfun
2 жыл бұрын
Glad it helps!!
@jakelee353
2 жыл бұрын
Great video! Really useful.
@excelisfun
2 жыл бұрын
Glad it is useful for you!
@randomthings596
Жыл бұрын
You're a genius!
@MySpreadsheetLab
7 жыл бұрын
Cool 'Paste All' trick! Thanks Mike
@excelisfun
7 жыл бұрын
You are welcome, Kevin!!
@oppie1636
7 жыл бұрын
Thank you for the awesome videos!!! learning so much about excel through your videos
@excelisfun
7 жыл бұрын
I am glad that you are learning a lot : )
@erifirman9556
2 жыл бұрын
Thank you so much Mike👍
@vincentluciani
4 жыл бұрын
Thanks a ton for the video, it made me gain a lot of time !
@excelisfun
4 жыл бұрын
Glad it helps, Vincent!!!
@PlanetELC
2 жыл бұрын
thank you!!!
@excelisfun
2 жыл бұрын
You are welcome!!! Check out tomorrow's (thanksgiving day) video that I will post: it has a five different ways to accomplish this same goal for a single column of values: )
@renashbell4317
2 жыл бұрын
yo this help me alot to re arrange my table
@excelisfun
2 жыл бұрын
Glad it helps!
@haimkichik
4 жыл бұрын
You are Good, man!
@y7iia
4 жыл бұрын
Excellent trick. Thx
@zaighamuddinfarooqui1705
7 жыл бұрын
Mike you and your skills are amazing!!! : )
@excelisfun
7 жыл бұрын
Thank you sir! I will try to do even better next time, but just for the sake of fun : )
@akashtribhuvan8124
5 жыл бұрын
Any video that will help to convert the dat to columns, so that I can apply pivot to it and design as I want? Example: day1- product 1- amount
@christianmalleux9798
3 жыл бұрын
Thanks
@mohamedchakroun4973
7 жыл бұрын
Wonderful tricks Mikeeeeee
@excelisfun
7 жыл бұрын
I am glad that the tricks help, Mohamedddddddddddddddddddddd!!!
@pannagesh6244
4 жыл бұрын
Really excellent unknown trick .
@excelisfun
4 жыл бұрын
Glad it helps, Pannagesh!!!
@suzannearonson
3 жыл бұрын
OH MY GOD!! This is amazing. Thank you. Do you have a formula to repeat the row headers and column headers for the data? So all the info would be in 3 columns? Thx
@basudevbasak309
2 жыл бұрын
Have the same question Mike. Pls help
@Luis52962
4 жыл бұрын
Great video. Thanks. Helps a lot!
@excelisfun
4 жыл бұрын
You are welcome a lot, Luis!!!
@shau78
7 жыл бұрын
Mike thanks a lot for this. I have a small request: have done a video on converting say 4 way table to single column table by addition or averaging? Like for example 1 formula which finds a minimum value of each line and sums the minimums up. I would appreciate that tutorial.
@NamTran-yu8nk
Жыл бұрын
Great video! i have a question: Assuming somes of the cell in the table are blank. Is there a way to skip these cell and cot paste them in the column?. Thanks!
@sjn7220
7 жыл бұрын
Very nice; I do this quite often. I use quotient and mod instead of roundup and mod but the effect is the same. Thanks.
@excelisfun
7 жыл бұрын
You are welcome!
@entertainmentgalaxy971
7 жыл бұрын
Massive Fun. Thanks
@chris-zu6sf
3 жыл бұрын
How do I modify this formula to specify the columns I want to table into a single column. For example, I want to table columns 'D and E' only. Then I can build a reusable template to copy and filter spreadsheets. Also, how would I alphabetize the table results? I think setting the range on the 2 columns while extending the rows may work. Because, the formula is encoded on 'Cell N7'. Thanks!
@micoloco.brawlstars
3 жыл бұрын
Excelent
@pawjeppesen-ifttttricks605
4 жыл бұрын
Great video. One question, though. What if I have blank cells somewhere and I want to exclude those from my list? //Paw
@khsalama26
4 жыл бұрын
thanks
@excelisfun
4 жыл бұрын
You are welcome!
@Shuman99
2 жыл бұрын
when i click on paste all, some numbers are literally replaced with hashtags despite the column width being wide enough and it also missed the first column i copied (even though it still appears on the clipboard) - what is the fix for this please?
@debjitchakraborty9176
7 жыл бұрын
Love You :)
@excelisfun
7 жыл бұрын
Thanks for the love!
@lg864
4 жыл бұрын
Always interesting to compare formulas... heres mine: A2=if(A1=8,1,A1+1) .....drag down for column. A9=IF(PRODUCT(A1:A8)=A8^8,A8+1,A8) ....drag down for row
@umeshmahadik3946
7 жыл бұрын
If there is an empty cell or 0 amount in any row, how should we skip that in our formula?
@giuseppemaffia302
3 жыл бұрын
grandeee
@1965mlflowers
5 жыл бұрын
does not work. even downloaded file and did not work, paste all function only pulling one list. great idea, need to figure out why not working
@janalcoba
3 жыл бұрын
@ExcelIsFun Is there a way to do this in Power Query?
@excelisfun
3 жыл бұрын
Unpivot Other Columns on Day Field, then remove fields you don't need. Like: let Source = Excel.CurrentWorkbook(){[Name="StartCrossTab"]}[Content], #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Source, {"Day"}, "Attribute", "Value"), #"Removed Columns" = Table.RemoveColumns(#"Unpivoted Other Columns",{"Day", "Attribute"}) in #"Removed Columns"
@dougmphilly
7 жыл бұрын
wow...
@Messy-shell
7 жыл бұрын
Hi Mike, Great video! How about use unpivot function in power query, that's also amazing.
@excelisfun
7 жыл бұрын
Power Query is awesome!!!! But as I say in the video I did not want a solution that required Refresh : )
@tomleszczynski2862
4 жыл бұрын
Does not work, excel 2007 is randomly choosing how many items to paste. it varies wildly, but it has yet to actually paste them all.
Пікірлер: 62