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!!!
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.
First name Last name