Selecting Data from an excel column

[#1]

i get monthly reports from the security departments where there are a few tables in the sheet. the column names are consistent but the amount of data are not.

but the thing about the tables is that it can start anywhere and i cannot define a cell... i know how to get data when they are laid horizontally using textbetween, right, left etc but is there anyway to get the data the same way when they are arranged horizontally

thank you in advance

Akhila de Costa

[anbu1984]

Can you show sample data?

[#3]

here there are 3 tables in one sheet... i want to get them as 3 seperate tables, is it possible?

[vijetas42]

Hi,

Yes, At the time of loading Excel on the top you will find drop down list to select particular sheet from excel.

Every time you need to load excel with different sheets that will create 3 different tables

Regards,

Vijeta

[vijetas42]

Hi,

See the Table dropdown where you can select sheet name

[#6]

the thing is there are a lot of tables in in one sheet.... i have to extract multiple tables from a single sheet

[MK_QSL]

Like this?

[vijetas42]

Hi,

In this case you can select columns at a time which you need in specific tables whichever columns you don't require just click on cross symbol at corner of each column header name at the time of loading.

[#9]

the columns are not consitant with regard to the cell number... please see the attachment if possible