I want to display specific data from Google Sheets on the screen. For example, if I select B16 (Bapatla) in a spinner, I want to show only the data of C16 and D16. I have tried a lot but couldn't find a solution. Can anyone help?

[Lokesh_Samarth]

[ABG]

If you have downloaded the entire sheet as a CSV table and converted it to an AI2 table, you can use one of the advanced AI2 list filter blocks to select the row that has that value in column 2, then select items 3 and 4 from that row.

[Lokesh_Samarth]

Actually, I want to display data column-wise, specifically if I select B16, then C16 & D16; if I select B17, then C17 & D17; if I select B18, then C18 & D18, and so on. I need to fetch data for around 800 columns, but I can't store it by index in a CSV file because the values in Google Sheets will change day by day. (I want to link (connect) with Google Sheets.) If there is a solution, please let me know.
thanks

[TIMAI2]

This will select all items in columns C & D

If you want to select individually then, for example:

[Lokesh_Samarth]

Wow, this is working! Thank you so much, I was troubled for the past two days as the entire sheet was coming. Once again, thank you from the bottom of my heart. Can we design and view it with a title along with it?

[Lokesh_Samarth]

[Kumaraswamy]

Hi, it's advised to keep title a bit shorter and you can add your full query into post.

[Lokesh_Samarth]

Sorry, sir. I am new to this platform. I won't make such a mistake next time.

[Kumaraswamy]

It's completely alright

[Lokesh_Samarth]

Is there any solution for this?

[TIMAI2]

Use list blocks to extract list items to labels

[ABG]

@Lokesh_Samarth

I need to fetch data for around 800 columns,

That would require a SELECT * in SQL, to get entire rows.

Such a large number of columns implies you need more than one sheet, and need to turn columns into rows in a detail sheet.