The New ‘Expand’ Function in Excel | Create Datasets Quickly with Expand Function | Best Explanation

[@SlametPundya]

The best explanation about expand function ever. Thank you

[@guranslifes]

awesome. i was looking for it this morning and found out at afternoon without looking for it.

[@MadindaRiva]

Superb!! waiting more the practical video like this

[@TopBam]

Great video! Here is an easier to use formula to accomplish the job: =TOCOL(Table1[Product]&EXPAND("",,ROWS(Table2[month]),""))

[@premiertraininghub]

Thanks for liking the video. Thats also a nice way of accompalishing the task but whether it is easier or not is a perception :). There is one thing that you missed to mention in your solution, so let me add the same for the benefit of readers. In the method advised by you, for creating the 2nd column (Month column) in the output database, we would need to modify the TOCOL formula by adding a 3rd argument as "1", else the formula would create an incorrect database (this is in addition to reversing the Tables as shown in the video). The formula for the month column in the formulas advised by you would become :- =TOCOL(Table3[Month]&EXPAND("",,ROWS(Table1[Product]),""),,1) But i am not sure whether appending a blank array with a table would be intuitive for many people.

[@ankursharma6157]

Hi Sir, Thank You for sharing a very interesting video on EXPAND 🙏🏾 Sir, what if the Products are: Belt Goggles Camera The final Product list should have the items in the same order (Belt, Goggles, Camera). The solution in the video will sort the item in A-Z order. Please suggest a solution. Thank You!

[@alexandrarato743]

Many thanks for the explanation. I saw this video "en passant" yesterday and I'm putting it to use today! All the best for your channel - Hopefully you will get many more subscribers very soon!

[@premiertraininghub]

Thanks Alexandra for liking the video. Glad you found it useful.

[@joesmith4254]

Thanks a lot for the video. I have made similar output with much more work the last many years. Now I have just to figure out how to expand with 3 or 4 tables. If anybody have an Expand formula ready using 3 or 4 tables, I will very much appreciate to see it.

[@joesmith4254]

Thanks a lot PTH - it's really an elegant solution to expand items in a list to a dataset. Just had to practice a bit to expand formulas to use 3 tables. This is going to save me a lot of time.