How To Collate Tables

[Dalski]

Hi guys, can anyone advise the process to generate one big table from a bunch of little tables where rows are in the exact same order as the original tables?

I've spent 3 full days trying to get the attached pbix to work but the Index field is showing that some rows are not being displayed in the correct order and I don't know why?

Take the Query Grab Tbl 1-9 on page Tbls 1-9: it jumps from Index 204 - 238. Can anyone advise what I'm doing wrong?

I thought it may be because I have some blank rows as in this article but I don't think that's the case. Sometimes it seems this happens when a descriptive column is used and it doesn't have any values (basically the headers in the pdfs). However the vast majority of the time these are being processed correctly. Obviously I desperately need these in the right places.

Grateful of any guidance, and willing to hire someone if they can do it. I can't loose any more time on this.

[HotChilli · Accepted solution]

The index column has the wrong datatype.  It's set as decimal number, it should be whole number.  And it should be set as 'do not summarize.'

Make that change on each of the three 'Grab ....' tables

You'll probably need to change the visualisations as well. Set the Index in Values to 'Don't summarize'

[Dalski]

HotChilli, I can't thank you enough. I've spent 3 days on this and you've just fixed it in seconds with your beautiful brain. Thank you so much!

I left the Index column as decimal format because that was the default setting for an index column which seems strange, again thank your brain for me.

[HotChilli]

Happy to help.

The question was clear (with picture and pbix) and that makes it a lot easier to investigate.