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