tables query

My data is from a CSV that dumps into one giant excel table. There are ~100 tables that I need to break into individual tabs & tables in a workbook. Once this is done, I can analyze and adjust the data. I will then need to recombine the data back into one giant excel table to resave as a CSV...

I am able to generate an "Item Master Report" from my company's Oracle portal that shows all the available information about all of our products. At this point, the file is roughly 18,300 Rows and 131 Columns. I used a Power Query to delete irrelevant columns to cut the file down to 5.70 MB...

Hello Dear All, There is a table in excel 2016 made out of a SQL Query which is linked to a few pivot tables, each month we open the SQL query in Query Editor and change the parameters and save. Later we refresh all the pivot tables to update. My Question is: Is there a way to change or update...

Hello, So I have a table with two columns: one with the year and the other with savings. The first year row is one formula: Cost Per Year - LED Cost Per Year. The rows following that are a different formula: Previous Row*Inflation Rate + Previous Row. However, the table wants all the rows to...

I have a workbook (named Pay Ranges) with pay grades 1 -25 and 3 pay rates for each grade based on years in title. In another workbook (named Scenarios) I am running scenarios based on data in the Pay Ranges workbook. The scenario workbook contains the employee name, current pay grade and...

Hello All Excelions! Here my problem: (cause I'm a TOTAL newbie/excel idiot) I have a client list/table that gets new data each day. I need to create separate lists/tables on new sheets from the main data sheet (ALL) base on certain conditions/criteria... The All sheet has different...

I just started using tables to store my data and I love that I can reference fields without explicit cell references.. Nevertheless, when I need to look up data into one table from another, I use the same old index(match).. which of course works great, but considering the field/record structure...

My raw data contains many fields, including fields A, B, C and D. I ran queries to create two new tables: the A-B table and the B-C table. I took the duplicates out of the A-B table and added an autonumber field, so now each unique A-B combination has a number. This will of course become the...