Oh my goodness Victor: What a terrific example and solution.... I used to create these multiplication tables many times when i was learning how to do mixed cell references years ago in excel 2007 from a Mike Girvin video . Brought back great memories. By the way, the division trick to get the division error was brilliant to visualize the final list of numbers . Quite elegant as always! Thanks for sharing your knowledge
Dear good sir, I discovered your channel only 3 days ago and since then I have been watching your videos whenever possible - such is the power of (your) thinking. So, many thanks for being there! P. S. Is it possible to present an Excel challenge here?
@@ExcelMoments Thank your so much for your answer, you are very kind! The question/problem is kind of similar to the one addressed in your "Sort "Messy" Excel Data" video but while in that case it was possible to use WRAPROWS because each part of the data consisted of the same number of rows, is there a way to proceed when this is not the case, i.e. when the data is structured in a way that each record consists of a different number of variables, i.e. it is contained in a different number of rows? E.g, the data is contained in 1 column and structured like this (where r = record or start of a new record): column 1 r1 a b c d r2 a b c d e r3 a b c d The desired outcome is this: column 1 ... column 6 r1 a b c d r2 a b c d e r3 a b c d
@hagiasofia6179 Great question. Is there something that identifies r1,r2..like is there a special character or something that tells us this is the beginning of the record or the end of the record
![Felix "Unfair" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/Oswujxm2Ag0/mqdefault.jpg)
Thanks Victor, another masterclass in Excel
Thanks Steve, I appreciate your comment
❤love u so much victor! your channel is pradise of wisdom!
Oh my goodness Victor: What a terrific example and solution.... I used to create these multiplication tables many times when i was learning how to do mixed cell references years ago in excel 2007 from a Mike Girvin video . Brought back great memories. By the way, the division trick to get the division error was brilliant to visualize the final list of numbers . Quite elegant as always! Thanks for sharing your knowledge
The matrix approach you have given is spectacular. Applause Victor!!
Thank you very much for your comments
@@ExcelMoments Mr.Victor May be you are THE ONE not the Neo Anderson
Dear good sir, I discovered your channel only 3 days ago and since then I have been watching your videos whenever possible - such is the power of (your) thinking. So, many thanks for being there! P. S. Is it possible to present an Excel challenge here?
Yes, please, by all means
@@ExcelMoments Thank your so much for your answer, you are very kind! The question/problem is kind of similar to the one addressed in your "Sort "Messy" Excel Data" video but while in that case it was possible to use WRAPROWS because each part of the data consisted of the same number of rows, is there a way to proceed when this is not the case, i.e. when the data is structured in a way that each record consists of a different number of variables, i.e. it is contained in a different number of rows? E.g, the data is contained in 1 column and structured like this (where r = record or start of a new record):
column 1
r1
a
b
c
d
r2
a
b
c
d
e
r3
a
b
c
d
The desired outcome is this:
column 1 ... column 6
r1 a b c d
r2 a b c d e
r3 a b c d
@hagiasofia6179 Great question. Is there something that identifies r1,r2..like is there a special character or something that tells us this is the beginning of the record or the end of the record
@@ExcelMoments To make it simple let us just say that the start of every record contains the same text string, e.g. "NEW".
❤
We go again!!