Thank you. I got the answer I needed. the first 3 minutes of watching your video

Gracias Alejandra, mas claro imposible. Excelente entrega!!!!

You're the best! Thank you for helping me solve this problem!

It is great to see you back posting videos! Thanks for the interesting and useful video. Nice use of table.splitat. I would make a small change to the steps to avoid hardcoding the split point of the tables by inserting few steps adding an index column, filtering down to a known value found in the row to split at and drilling down to the index number: ...... AddIndex = Table.AddIndexColumn( Table001, "Index", 1), DrillDown = Table.SelectRows(AddIndex,each [Column13] = null)[Index]{0}, PrdcDataSet = List.Transform(Table.SplitAt(AddIndex, DrillDown), each let a = Table.RemoveColumns(_, "Index"), b = Table.PromoteHeaders(a), c = Table.SelectRows(b, each [#"Product #"] null), d = Table.UnpivotOtherColumns( c, {"Product #"}, "Year - Qtr", "Amount"), e = Table.SplitColumn(d, "Year - Qtr", Splitter.SplitTextByAnyDelimiter({" - "}),{"Year", "Qtr"}) in e ......... Not overly important on such a small dataset but a for a large dataset it might save a lot of scrolling around.

Muchas Gracias @Alejandra Horvath siempre algo nuevo que aprender con tus entregas. Saludos desde Chile

Excelente mini training💪🤗. gracias Por otro lado, se te extraña mucho con los "live"

Thanks 😊 Keep bringing these videos . I would request you to please make videos on the excel bi challenges that comes everyday on linkedin Thanks in advance

Great job! I enjoy your videos and learn a huge amount of tips. Thank you so much!!

Alejandra, Excellent results.

Very interesting and full of knowledge. Thanks

Excellent 👌👍👍

Magistral como siempre, saludos estimada Maestra Ale.

as you always say, excellent!!

Awsome !

Great mam... I am learning from you... Love your videos

Hello Alejandra, thanks very much for this very interesting video. Do you have a video explaining how in PowerQuery to split a table in N tables according all the N distinct values ​​in a column ? Thanks very much in advance for your help.

Hola, excelente explicación, una duda consideras que con muchos datos es más eficiente al resultado que tú realizaste únicamente tienes unos cuantos pasos en el editor, si lo hiciera utilizando las opciones normales desde la interfaz de usuario seguro quedarían muchos más. muchas gracias que estés muy bien 😁, te evi un fuerte abrazo 🤗

Hi Alejandra. Very good. when to choose between Table Ou Page, i have always this doubt? Tks in advance