Forum Discussion
Searching a complex set of data
Interesting formula! I don't think I could have created that. Are steps such as
Table.Split(Source, 6)available from the UI or do you have to know the commands to enter them? At least reading your query caused me to dip into the joys of 'selection' and 'projection' once more with a little more sense of purpose.
One thing that occurs to me is that, if Excel 365 is now Turing complete, I should be able to replicate the action of any PQ step using a suitable defined Lambda function. In this case, a list of tables could be replicated as an array of thunks. Unfortunately replicating the functionality of Table.Combine, though possible, is something of a nightmare. The sooner Excel allows lists of arrays the better!
Talking of nightmares, we should persuade Greg_Taylor to post a sample of his workbook here. The data blocks appear to serve the role of a sequence of forms, separated by blank rows and any field can display across several blank columns before the next set of values are encountered. The set task was to sort the 'forms' but I was sorely tempted to normalise the data format instead.
