I have been looking for this solution, it worked with what I had in mind, then exceeded my expectation because it dealt with a real life solution! Thank you so very much!!!
When I delete one column from original data and then refresh my query It gives me error that column was not found. Suppose , I remove column 9 and then refresh my query it gives me that column 9 was not found. How to solve this problem?
This is great, but am having issues with my table. I have these columns: Company, Booth Number, First Name, Last Name, Email, Job Title, First Name2, Last Name2, Email2, Job Title2, ...Up to 5. When I get to the point of pivoting the names and titles and emails, it gets very wack. Is it because some cells are null?
@@Sandybrar3588 Pivot is probably the most powerful feature of excel. Here is a short course if you are interested - th-cam.com/play/PLr7RyN24TvNam49iFpBGV9GYR5PrnqmyZ.html
I have been looking for this solution, it worked with what I had in mind, then exceeded my expectation because it dealt with a real life solution! Thank you so very much!!!
Glad it helped!
Omg !!!! I work in logistic and i had to do this thing and i i thought i will never find how...it 's perfect !!!!! Thank you so much !!!!
Excellent. Very precise and easy to understand.
Thank you, you aren't just Goodly, you're Godly. :)
Thank you very much for this video !
Thank sir so much, I have been looking for this solution a long time.
OMG! Finally, found the solution! Thank you so much!
This is fantastic. It helped me solve my data formatting problem.
Thank you!! This was a huge help!!!
Thank you so much! you're such a great help!
Happy to help!
You are the man. Thanks again.
Thanks, good Sir! That was exactly what I needed. What a good work!!
Glad you found it helpful
This is what I need. Thank you very much.
Glad it worked for you :)
VERY GOOD
Hi, Mr. Chandeep,
I found this video very helpful, but I am unable to find any " From Table/Range" option in the Data tab.
Awesome and to the point.. Thanks a ton :)
Super useful! Thanks Goodly :-)
Thanks man!
Awesome
Thank you !!!
When I delete one column from original data and then refresh my query It gives me error that column was not found.
Suppose , I remove column 9 and then refresh my query it gives me that column 9 was not found.
How to solve this problem?
This is great, but am having issues with my table. I have these columns: Company, Booth Number, First Name, Last Name, Email, Job Title, First Name2, Last Name2, Email2, Job Title2, ...Up to 5.
When I get to the point of pivoting the names and titles and emails, it gets very wack. Is it because some cells are null?
send me your data sample - goodly.wordpress@gmail.com
with clear instructions. Thanks
Pleas help me table form is not wok convert 30 rows but not right to 30 rows show this only show to 1 rows
Hey I just want reverse of this?
I mean I have given that expected result and convey into upper form
Can u help ?
Just make a Pivot!
@@GoodlyChandeep thanks alot dude ♥️
Although I was not knowing what is pivot😂 i just searched pivot on TH-cam and my job is done
@@Sandybrar3588 Pivot is probably the most powerful feature of excel.
Here is a short course if you are interested - th-cam.com/play/PLr7RyN24TvNam49iFpBGV9GYR5PrnqmyZ.html
Nice Nice Nice
you save my time...take love from me................
Thank you :)
Thanks a ton