You continue to amaze me with all your video tutorials Professor! What about unstacking uneven records and the fields are not consistent in the order of appearance. I hope you can do a tutorial on how to solve that using power query.
Each of these unstacking methods is amazing, and I certainly will be rewatching this video again and again until I get the processes down cold. My data, however, will need a bit more work, as I have a table of records that is six columns wide. I don't have a clue as to how I might unstack individual records that are already in tabular form but repeat incrementally. Can you help?!
Nabil ... Sensational ... All the methods you've used are incredible. Except for VBA I know absolutely nothing (ahahah), the others I like a lot, but ... Power Query is my favorite, I have Office 365, but the Dynamic function has not arrived yet for me. Thanks for the material provided. A great one from Brazil. Thank you very much!!! I'm using Google Translate, I do not know if the translation is giving to understand.
Dear Luciano (My loyal subscriber from Brazil), I am glad you liked the Video. I know that not everyone uses VBA but I am offering the different methods and each one can select what they want (I even show the start time on the timeline), as if you go to an Open Buffet (All you can Eat Buffet) you do not necessarily have to eat everything. No worries... Google Translate is doing Fine... Thank you for your comment and share it on your social media
Spectacular, amazing, incredible. Mr. Nabil have any body told you that a good "Screenwriter" is hidden in you?💖 Please try to record a tutorial on extracting/un-stacking records from a "Folder" containing files e.g., Excel workbooks or text, CSV files using the Power Query. I have found good stuff on other channels but I believe that your tutorial would be of another level.
Excellent. To your question, I prefer PQ method. Could I ask, is there a method to deal with unevenly stacked records, where, for instance, the records occur as 10-string then 11 and then 10 or 9? Thank you.
Dear Nabil, The first one, if there is not fix gap between record then how i can handle this? like ( gap between first name to second name 9 row gap ), second one is if the last record phone number will be same number then the formula is returning same record. kindly tell me because my record the last number is same record then start new one
The dynamic formula blew my mind
Gracias por compartir tus conocimientos. Saludos
Extraordinaria explicación maestro. Saludos desde México
You continue to amaze me with all your video tutorials Professor! What about unstacking uneven records and the fields are not consistent in the order of appearance. I hope you can do a tutorial on how to solve that using power query.
Wow!!!! Mind blowing! Thank you
Wonderful explanation, thank you teacher. greetings from Mexico
Thank you Eduardo... All the Best from Toronto Canada
Each of these unstacking methods is amazing, and I certainly will be rewatching this video again and again until I get the processes down cold. My data, however, will need a bit more work, as I have a table of records that is six columns wide. I don't have a clue as to how I might unstack individual records that are already in tabular form but repeat incrementally. Can you help?!
Great video sir. 👍
Thank you
You are welcome
Nabil ... Sensational ... All the methods you've used are incredible. Except for VBA I know absolutely nothing (ahahah), the others I like a lot, but ...
Power Query is my favorite, I have Office 365, but the Dynamic function has not arrived yet for me. Thanks for the material provided. A great one from Brazil. Thank you very much!!!
I'm using Google Translate, I do not know if the translation is giving to understand.
Dear Luciano (My loyal subscriber from Brazil), I am glad you liked the Video. I know that not everyone uses VBA but I am offering the different methods and each one can select what they want (I even show the start time on the timeline), as if you go to an Open Buffet (All you can Eat Buffet) you do not necessarily have to eat everything.
No worries... Google Translate is doing Fine...
Thank you for your comment and share it on your social media
Here is a link to get Office Insider
insider.office.com/en-us/
Spectacular, amazing, incredible. Mr. Nabil have any body told you that a good "Screenwriter" is hidden in you?💖 Please try to record a tutorial on extracting/un-stacking records from a "Folder" containing files e.g., Excel workbooks or text, CSV files using the Power Query. I have found good stuff on other channels but I believe that your tutorial would be of another level.
Thank you Zaigham... you always motivate me
more than great♥
Thank you
Excellent. To your question, I prefer PQ method. Could I ask, is there a method to deal with unevenly stacked records, where, for instance, the records occur as 10-string then 11 and then 10 or 9? Thank you.
Query is the excellent way
I agree Sameh... power Query is really magical and easy
With functions, is it not better to use a unique personal data instead of the telephone number?
The Dynamic Array Functions take the cake!
Now, if only my O365 version would have that already...
For now I’ll settle for PQ.
OK, the Excel Classic functions approach is not to bad either... :-)
Here is a link to get Office Insider
insider.office.com/en-us/
Dear Nabil, The first one, if there is not fix gap between record then how i can handle this? like ( gap between first name to second name 9 row gap ), second one is if the last record phone number will be same number then the formula is returning same record. kindly tell me because my record the last number is same record then start new one
Wonderful, I would like to use Power Query, since not having Office 365.
Power Query is great
I also have unevenly stacked data, can you help? Thanks in advance.
There MUST be any kind of pattern... It's robotic at the end
Thanks
power query