data set

Hello, everyone! Every day, I use several reports that look like the table below (I can export as csv or xlsx.) I need to be able to pull data only from certain headers - specifically all 1900 and 3900 groups. (In my actual data, that will include 1901, 1902, 1903, etc.) But I need to exclude...

Hi, I am trying to think of ways that i can take a block of numbers say 10 col, 10 row. I intend to somehow 'profile' a completed table of numbers and then produce a replica set but slightly different following the same profile (i dont know how else to say it.) You can see there is a trend, how...

Hello, I have a set of data that contains data using a combination of columns and rows. I would like to transpose the columns into the rows so I would be able to create a load file. I'm not quite sure how to explain this but please see the screen print below to see what I am trying to...

I have data on books and authors in simple two-column format, i.e. book-author pairs: Author1 Book1 Author1 Book2 Author1 Book3 Author2 Book1 Author2 Book3 Author2 Book4 Authors may have produced more than one book and each book may have multiple authors. I need to turn those cases into rows...

Hello All, New to the group so I apologize if I am not doing this correctly so any and all suggestions for a smooth intro/responses/conversation are welcomed. I have a spreadsheet where every second row is a new entry/field with 5 columns of information. Column ABCDE and Row 1& 2, correspond...

Hi, I would like to extract all info from excel tables into a word document verbiage by creating a macro/vba but my data is not set up consistently. There is not a consistent range as it varies daily and there are three different entity category(ABC, DEF, etc) I then copy each of the...

Hi there. I have a two-dimensional table that I'm trying to turn into a line chart. The issue I am running into is that I have more than 255 Data Series, which is an Excel limitation. In column A, there are 600+ Billcode values. These are my data series. Across the top of my table, in Row...

I have 4 columns of data with field names/column headers (people, office, case number, date). I have over 60,000 rows of data within those 4 columns. A single case number can have multiple people work on it over a given period of time in different offices (ex: John worked on case number 3 during...

I have 4 columns of data with field names/column headers (people, office, case number, date). I have over 60,000 rows of data within those 4 columns. A single case number can have multiple people work on it over a given period of time in different offices (ex: John worked on case number 3 during...

I'm trying to use a sumifs formula to pull data from multiple tabs into one data table. One of my criteria is the name of the tab in my data set. However, I cannot seem to pull the data that I want to from the individual tabs. I have over 20,000 records divided by 16 tabs so I want to automate...

i need help to create a formula that will randomly select from a preset list but take care not to create duplicates unless all the items in said list have appeared at least once. I am hoping that somebody can advise me so that I don't have to spend all the time figuring out the best way to do...