table query

  1. C

    Extract some rows & all columns from a table - filter each row across all columns by a text value

    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...
  2. K

    Power Query Issue

    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...
  3. C

    MAKE TABLE QUERY mismatch in ROWS!!!

    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...
  4. T

    Access query one column results into new column

    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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top