I have a worksheet that looks like this:    Right now each Number contains a varying amount of Companies and Company Numbers.  I would like to set up the spreadsheet so each Company has their own row for each Number.  See below for visual representation.  I would like to convert the spreadsheet for each existing row like this:    So row 2 would be converted into row 2 and row 3 to look like this:    There are thousands of rows already so doing this manually would be quite the pain.  Is there a way to use Excel functionality to convert the spreadsheet to fit this?
122096
I would like to change this:  Filer   ShareName       IPAddress1    IPpaddres2    IPAddress2    ... ... .... ServerA /share1/tools   192.168.1.52  192.168.1.65  192.168.1.158 ServerA /share/library  192.168.1.65  192.168.1.61  192.168.1.155 ServerB /share/tools    192.168.1.158 192.168.1.159 ServerD /share/misc     192.168.1.7 .. ... ..... .......   To this, in a new worksheet:  Filer   ShareName       IPAddress ServerA /share1/tools   192.168.1.52 ServerA /share1/tools   192.168.1.65 ServerA /share1/tools   192.168.1.158 ServerA /share/library  192.168.1.65  ServerA /share/library  192.168.1.61  ServerA /share/library  192.168.1.155 ServerB ... ... ServerD ... ... .. ... ..... .......
27892
I would like to shift data found in a column to a row by Key field. I have a table, within a geodatabase, set up similar to what's below.  KEY_    Value 123     Yellow 123     Blue 456     Red 456     Yellow 789     Green 246     Green 246     Orange   I want to create a table that moves the data in the Value field to rows based on the KEY_ field. The result will look like what's below.  KEY_    Value001    Value002 123     Yellow      Blue 456     Red         Yellow 789     Green 246     Green       Orange   Does anyone have an idea of how this can be done? I tried using the Transpose tool Esri offers but it didn't produce the result I'm looking for. I have basic understanding of Python.
50643
I have a spreadsheet in the newest iWork Numbers.app, with something like:  CATEGORY | POINTS         HW | 100       HW | 100       NW | 12       HW | 50       NW | 23   I want to just sum up all the Category = HW into a cell: I'm not sure how. I think I need to use the SUMIF() function but I get stuck afterwards.
86570
I have an Excel spreadsheet with 2 worksheets. The first is just a header row and a single column of item names. The second is a list of item groups, with a header row and a title in the left most column, with each subsequent row being one item or another from the other sheet:  Sheet1:            Sheet2: +-------+--+--+    +-------+-------+-------+-------+-------+ | Item  |  |  |    | Group | Item1 | Item2 | Item3 | ... +-------+--+--+    +-------+-------+-------+-------+-------+ | Shirt |  |  |    | A     | Shirt | Hat   | Tie   | +-------+--+--+    +-------+-------+-------+-------+-------+ | Hat   |  |  |    | B     | Socks | Shirt | SHOES | +-------+--+--+    +-------+-------+-------+-------+-------+ | Socks |  |  |    | C     | Hat   | Socks |       | +-------+--+--+    +-------+-------+-------+-------+-------+ | Tie   |  |  |    | D     | Tie   | Tie   | Socks | +-------+--+--+    +-------+-------+-------+-------+-------+ | ...   |  |  | +-------+--+--+   I'd like to conditionally format all the cells in "Sheet2" such that any value that does not match a value in the first column of "Sheet1" is marked with a red background; those that do are marked with a green background. So all the cells in this example starting at B2 would be green except the value "SHOES". The value beneath that has nothing entered so would not be formatted at all.  The formatting rule for green I've tried is:  =AND(NOT(ISBLANK(B2)), COUNTIF(Sheet1!$A2:$A1000,B2)&gt;0)   For red, about the same:  =AND(NOT(ISBLANK(B2)), COUNTIF(Sheet1!$A2:$A1000,B2)&lt;1)   Both rules are "applied to" somewhat arbitrary range (I'd like it to apply to the whole sheet, less the topmost and leftmost row/col):  =$C$3:$E$10,$C$36:$Q$50,$E$11,$C$11,$C$2,$E$2:$Q$2,$C$12:$E$35,$F$3:$Q$35   This semi-works, but the results are unpredictable. Some values highlight as I expect but only for a few rows, and others don't. Probably my ranges are out of whack somehow, but I don't use Excel nearly as much as I once did. Can anyone lend a hand?  Thanks!
43684
How do I transpose data in columns to rows?    If the data is:  Joe   some city   some state   Bob   no city   no state     and I use Paste Special » Transpose, I get    Joe some city some state Bob no city no state     What I want is:    Joe some city some state   Bob no city no state     I do not know VBA.
26464
I have a spreadsheet that I need to add new data to but the previous user made it so that I can't add data in a new row without moving down a lot of data which would mess with all the calculations.  What I am trying to do is to make it so I can add the new data to the side instead and still have the same drop down access the two separate columns. I attached a screen cap of an example of what I want below.  I have tried everything I can think of and all my searches come back with putting multiple columns in a drop down instead of just the data from them.  As you can see below the example has data in D1 to D5 and F1 to F5. If I wanted the dropdown to have the data from those columns how would I do it?  EDIT: Just to clarify there is data between the columns in the actual page which is why I can't just highlight all of it.
77769
For many of my datasets I have the same imported data duplicated numerous times, each iteration displaying the data values for a different column (in my case it's fish catch weight per gridded cell per year, so lots of iterations of the same grid, with a different pattern of values per year).  For presentation purposes, it strikes me as helpful to use the same scale for each year, so I go to the original data and divide the maximum value into (arbitrarily) 10 classes and manually input the values and labels after setting the desired colour ramp and input data field:   This is extremely tedious, not just the manual excel calculation part, but also the input interface for the values &amp; labels*, hence my intention to make use of the 'save style' option. HOWEVER: when I save the style as QML and load it for the next layer, it saves everything - including the data field (in my case, year). When I change this field, QGis automatically generates the values &amp; labels based on the data for that field, ditching all of the values &amp; labels I set.   Is there any way to avoid this happening &amp; thereby duplicate class number, values and labels for each field by simply loading a style? (somewhat meta) Am I going around this the wrong way, OR, is there a different face I could use to climb this mountain?
111439
I have a list of 200 cells in Excel. I put in names and would like the text color in the cell or the background of the cell to change according to the name written. I use about 25 names.
95136
In a Google Doc spreadsheet I would like to have each row the same height no matter how much text is in each cell.  I have tried "resize row" but no matter how many pixels I put in, the row expands downward to the height of the highest cell with full expanded text.  How can I force the row to stay a certain height and insert scrollbars for all text that is longer than that height?    Here's a video explaining what I mean:
121044
I searched for a similar question but couldn't find one..  I want to generate 10 groups out of numbers ranging from 1-60 (including both), with each and every group containing random and non-repeating numbers. How can I do this in excel?
98135
I have a sheet from which I want to get values from column A of every 30th row.   I tried =A(2+30) but it just gives me an error.
112223
How do I add a list of names to a spreadsheet and each time a specific name appears add the number 10 to cell.  For example, I would put a name like Jones in A1 then Jones in A5. And in D5 it would have the number 20. If I then add Jones in B2 then D5 would say 30. Add 10 each time Jones appears.  What   formula  would I use?
37884
I have hundreds of excel files which are all of the same format (i.e. 4 worksheets per Excel file). I need to combine all the files into 1 all singing and dancing file which must have the same format as the originals (i.e. maintain the four separate worksheets, which are all identically named).  While each file is structured the same, the number of columns (and the heading names) between sheet 1 and 2 (for example) is different. So it can’t be combined into one file with everything in one sheet!  There are two complications:   I need to create an EXTRA column in the merged file (on EACH sheet) to identify the source file (“file name”). The files contain a lot of zero data entries (e.g. 55 rows of useful data followed by hundreds of rows of zeros) which I need to remove from the merged file.   I’ve never used VBA, but everyone has to start somewhere I suppose.
93553
I have two excel sheets. I have to merge the two such that the values in one match with the other. For eg.  The first excel,    the 2nd excel  1  t                 1   tes1 2  5                 3   tes3 3  t                 4   tes4 4  g   Notice that in the first column of the 2nd excel, 2 is missing, so I want the first excel to look like this,  1 tes1 t 2      5  3 tes3 t 4 tes4 g   I am new to excel. Any help on this will be highly appreciated.
58187
I have a 20,000 line spreadsheet in Apple Numbers, and I need to fill a column with data. I don't want to sit there dragging down the fill handle for thousands of rows.   How can I fill the whole column with a value?
65998
Some days I'm working with extremely large Excel files.  They have too many sheets that can't be shown in one sheet tab. (see image)      So, I'm wondering whether or not we can show Excel sheet on more than 1 row. Many tries with Google don't help much.    Many tries but I still can't make Excel show the sheet bar the way I want (≥ 2 rows), so I'm working with some VBA Scripts kopischke suggested.    FYI, right click on |&lt; &lt;&lt; &gt;&gt; &gt;| button on the bottom-right corner show you a list of up to 15 sheets.  For more, click on View more in the list appeared.
105548
I make a new column in my attribute table and it has a default value (for example 0). I want to (probably using the field calculator) have the result that row 1 has the value 1, row 2=2 and so on, just like a numbered index.  I'd be thankful for a code example for the field calculator (including the use of $rownum (I think I need this for switching to the line)).