Help with import ranges

[lizmorton1990]

Hi,

I have created a google sheet that has what training people have done (all data tab), the data contains 4 courses and I then created 4 new tabs on the same sheet, one for each course. I then in each of the 4 tabs created an import range bringing all the data for the one course from the all data tab. My formula is this:

=QUERY(IMPORTRANGE("URL","Saba Report!a:j"),"Select * Where Col2='Skill Up, Stay Smart Module one: Firm Up Foundations'")

But my all data tab contains both text and numerical values, for example there is a payroll number column that has just pure numbers and also payroll numbers starting with IE. The 4 tabs bring through the numerical payroll numbers onto the tab but it doesn't pull through the payroll numbers starting with a letter, what am i doing wrong?

Also I have another column that shows time spent in the e-learning module and the format in the all data tab is like this 00:00:00, 0:00:21, 0:45:34 but in my 4 tabs it either pulls a blank or 0 - what do I need to do to ensure it pulls exactly what the data says in the all data tab please?

Thanks in advance, Liz.

 

[RoryA]

Do you need QUERY and IMPORTRANGE rather than just FILTER?

 

[lizmorton1990]

Hi Rory,

Very late reply, I don't filter as I want the formula to pull the relevant data into individual tabs, and then those tabs are imported into a different sheet for a vlookup to work.

 

[RoryA]

I don't follow - how does the FILTER function not achieve that?