1

I'm inserting two different tables successfully with ImportHTML. However I want to identify records in rows to which table it belongs.

In this particular case (link attached) the player Higuain plays both in Serie A (table,0) and UEFA League (table,3). How to add a record in the column Competition that would identify the table when I'm sorting each game by date (Sorted_Higuain_Last5Games) sheet?

https://docs.google.com/spreadsheets/d/1Tmlj8x-yKzsEpKcJ338O-0WXEK9TobVmrkUN7Aq6JAY/edit?usp=sharing

This should appear in both sheets when querying.

  • 1
    Looks like you should fill column Q of Higuain sheet with identifiers, so they are picked up in the sorted sheet. – user79865 Feb 23 '16 at 19:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.