pinarello
Member
- Joined
- Jun 21, 2019
- Messages
- 214
- Reaction score
- 4
- Points
- 18
- Location
- Germany
- Excel Version(s)
- Office 365
For example, when I look at the website https://www.oddsportal.com/matches/hockey/20210907/, the sorting by time shows me the leagues (separate row) and below that the games of this league at this time.
If I now import "Table 0" of this website using Power Query, then the first line with the text: "World "Club Friendly" is interpreted as a header line and all following lines with identical content are automatically deleted. So all friendlies starting at later times are now assigned to the league above.
For this case, there should be the import option "Table without headers", where all rows are imported without Power Query automatically deleting rows.
If I now import "Table 0" of this website using Power Query, then the first line with the text: "World "Club Friendly" is interpreted as a header line and all following lines with identical content are automatically deleted. So all friendlies starting at later times are now assigned to the league above.
For this case, there should be the import option "Table without headers", where all rows are imported without Power Query automatically deleting rows.