Store multi-column CSV as multiple lists

[Build-0-Matic]

I'm working on a small app in which I have a 2 column CSV file (with title headers) that I need to store in two lists (without headers).
I've tried to do it using the File block and the Datafile blocks, but both give me different problems.
The CSV is just NAME,VALUE so nothing complicated there.
When I use the Datafile, the data gets stored as (NAME VALUE) which makes it impossible to separate both fields.
When I use the File object, I can load the CSV and display it in it's entirety inside a Listview object, but I can't figure out how to separate it into two lists as Appinventor keeps throwing error messages at me.

Any help is very welcome as I don't see me doing this using a bunch of Add to list blocks.
Thanks

[ABG]

You need to learn how to use tables, and especially the Lookup in Pairs block.

FAQ Section: Lists

Introductory Making Lists (Concepts) - MIT Lists Chapter from MIT AI2 Online book Translatable copy of Lists Chapter from MIT AI2 Online book How to work with Lists - imagnity MIT AI2 List Blocks Help Page How to Display a List - MIT nb191 Advanced list blocks (filter, sort, map, reduce) Tables Dynamic-editable-html-table - @TimAI2 free-tableviewer-fully-style-customized-to-show-table-data (extension) - @Kevinkun Dynamic Table Layout and Table Listpicker (HTML) - @Taifun Dynamic Tab…

If that does not help, then

(Canned Reply: ABG- Export & Upload .aia)
Export your .aia file and upload it here.

.

[TIMAI2]

From this csv example:

Pet,Number
Cat,4
Dog,6
Goldfish,3
Rabbit,2
Gerbil,5

These blocks:

As @ABG suggests, you could just work with the full list...

[Spicy_Topics]

@Build-0-Matic

can't figure out how to separate it into two lists

Have you searched in this community regarding your doubt? There are more topics available. You maynot have create a topic if you would have searched about it.

Simple block is as suggest by taifun
Read file
list from table text ( thi will convert the while csv as a list) then by using select list item list parse into separate lists.

Make sure you are strong with the basic blocks

[Build-0-Matic]

Thanks for the links and ideas.
I've been googling this for some time (and even looked here) and just couldn't seem to find something that matched. I was even at the point where I was about to just read the file as text and implement my own splitting and sorting routine! But I knew there had to be something easier so I just avoided doing it.

Now I get it... the index doesn't always relate to the item itself but can be either the column or the row...

Thanks