Forum Discussion
Merge Tables into aligned row
Hi,
Paste your input data here.
Hi Ashish,
This is a link I'm using, but I'll end up with a larger URL list as per the code to extract them all.
https://www.racenet.com.au/horse/lankan-rupee
Basically pulling in the 3 tables it identifies:
Table1
Table2
Table3
| Trainer |
| Home Track |
| Colour |
| Age/Sex |
| Prize Money |
| Foal Date |
| Sire |
| Dam |
| Sire of Dam |
| Career |
| Last 10 Results |
| Season |
| Rating |
| ROI |
Hi Ashish,
Can you Transpose the data to have the Headers across the top, and the data underneath it (i.e. row 1 = Headers, row 2 = data).
I downloaded your sheet then and did that but had the same issue with the tables not lining up by row, as there are null values in the column headers where the other tables dont have data for it.
Link to file I've completed here
Ive included 3 example linkes in Sheet 3 that eventually I'd turn into a table, and then have the powerquery go through every link and return the data we have listed.
Hi,
I do not understand your requirement. Show me the exact result you want. Also, that link requires signing in.