table query

Hi, I need help determining the best way to extract rows from an Excel r x c matrix with all columns extracted and the rows extracted according to a text value that might appear in any, but only one of the array columns. Let me explain. The matrix: no more than twenty columns that over time...

I am having an issue in power query. My coworker with the exact same computer/setup/ and visibly same excel settings, working in Excel 2016 stand alone does not have the same issue, and is able to refresh the queries that I create by I am not. The issue is: Every time that I try and create a...

1.I import an excel table. 2.I create a query. 3.I make table query. 4.I run the query. 5.The resulting table appeared in the tables tab. I opened it. It pasted to 0 row when my orig table is 7000 rows!!! Similar problem: It pasted to 67000 rows when my orig table is 4000 rows!!! Please help...

I am using Microsoft Access 2003 I have a database table with names in it (Firstname, Lastname). I would like to combine two results(from one table) in one row. I cannot understand how to get Access 32003 to do so. Sample data: First name Last name Fred Jones Wilma...