This is an example:   I need to split by "  , " in a new row and duplicate the others The desired output on a new sheet:
45653
I'm compiling a database of business address info, including key staff for each business. The Google spreadsheet I've inherited for this project includes a column for 'key staff' (in column B), with multiple key staff names listed in the same cell, separated by line breaks (ie CHAR(10) ). There is one business per row. The number of lines in the 'key staff' cell varies row-by-row.  My initial sheet looks like this:    I need to do the following to optimize this sheet:   split each multi-line ‘key staff’ cell so each key staff name appears on its own row. This requires that new row/s be inserted beneath the original row. duplicate the data from all other cells on the original row (i.e. from columns A &amp; C:E), so that each new row contains the full data for each business I need an automated process - I'll have about 1000 businesses to process so can't do this with any manual steps   The sheet should then look like this:    Using =TRANSPOSE(SPLIT(B1,CHAR(10))) obviously only goes part of the way - it doesn’t insert new rows and doesn’t duplicate the surrounding column entries. All help gratefully accepted!
6478
I have en excel file with expenses(the amount of money spent is in one column), and in next column I have short description that is mostly made of multiple words. I want to "simplify" the description and assign a single word or two to each description, which would be in another column next to it. The problem is that the description is not "unified", for example I can have strings like "business lunch","business dinner at restaurant XXX", "coffee with journalists" etc., and I would like to assign these description "food" label. There are also different categories that follow similar pattern.   My idea was to create another table(on different sheet) - in one column I have keywords like "coffee","lunch","dinner" and in column next to them I labels that I want to have assigned, which is "food". I used vlookup function with approximate match, but it returns me incorrect results. For some reason the order of words in list seem to affect the results, and even though there is partial match(exact in one word of the string) the vlookup ignores it and returns something else. For example I have "parking at hotel xxx" and in table I have "parking"-"travel expenses" pair, the vlookup returns "food" label.   Can you help me solve this problem? (is there different approach that you would suggest?)
81191
I have two columns such as:  a   1  b   2  c    and I need to combine them like:  a   1 a   2 b   1 b   2 c   1 c   2   Is it possible with a formula?
111104
I want to sum the values of the rows of my data that have the same ID in the first column. My data looks like   data.txt  Id    a    b    c    d    e 1     1    2    3    4    5 1     2    3    4    5    6 1     3    4    5    6    7 2     4    5    6    7    8 2     5    6    7    8    9 2     6    7    8    9    10 3     7    8    9   10    11 3     8    9    10  11    12 3     9    10   11  12    13 3     10   11   12  13    14 4     11   12   13  14    15 4     12   13   14  15    16 5     13   14   15  16    17 5     14   15   16  17    18   Required results  out.txt  Id    a     b   c   d   e 1     6     9   12  15  18 2     15    18  21  24  27 3     34    38  42  46  50 4     23    25  27  29  31 5     27    29  31  33  35
71466
I need to combine multiple columns into a single column, so:  one     four    seven two     five    eight three   six     nine   Becomes:  one two three four five six seven eight nine
73208
How can I get Excel to increment ranges arguments by more than one row when I fill down a formula?  For example, if I want Excel to keep averaging the next five numbers in a column, how do I set the average function to keep it in a pattern throughout, without changing it from an increment of one from the first and last number of the previous formula?  Excel keeps giving me this when I fill down:  =Average(A1:A5) =Average(A2:A6) =Average(A3:A7)   I want Excel to do this instead:  =Average(A1:A5) =Average(A6:A10) =Average(A11:A15)   How can I do this by filling down?
89962
With Unix script, I'd like to add values in column 1 if text in column 2 is the same and print the sum.  I have a file that is:    7 GeneA 2 GeneB 6 GeneC 2 GeneB 9 GeneA   I want the output to look like:   16 GeneA 4  GeneB 6  GeneC   Thanks
79783
how can i copy values from one column to another? I'm using a workflow but i cant see the option "Copy List Item"   ps: I'm using Sharepoin On-line
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.
81960
When I have an output stream:  a b c d e   How can I double the newlines:   a  b  c  d  e
38733
I want to know if there is an easy way to split a line in a file into multiple lines, such as this:  I have  A B C 1 2 3 4   And I want to get something like this, based on the first string of the line:  A B A C 1 2 1 3 1 4   Basically based on the first string in the line create multiple lines with the second and third and fourth string and so on.
70443
The best workaround I have found so far is:  worksheet_name!$A$1:$YY   but ideally I would like to be able to simply write, e.g.:  worksheet_name!   So, does anyone know: is there a syntax for specifying a whole sheet as a range?
13068
Given a file like this:  1,768,12,46576457,7898 1,123,435,134,146 2,345,6756856,12312,1311 5,234,567465,12341,1341 1,3245,4356345,2442,13 9,423,2342,121,463 9,989,342,121,1212   I would like to list all rows (in bash terminal) such that the value in column 1 appears at least twice (in column 1). The result should be  1,768,12,46576457,7898 1,123,435,134,146 1,3245,4356345,2442,13 9,423,2342,121,463 9,989,342,121,1212
24487
How do I create a reference to a defined interval in several sheets?   Something like this: =SUM(Sheet1:Sheet2!A1)
57998
I know nothing about Excel, so the first thing I would like to do is to remove any duplicates from within the lists themselves.  But then I would also like any rows from list B that has a duplicate row in list A to be removed.  For example, if the email John@John.com is in list B and there is also a John@john.com in list A, I want to remove John@john.com from list B.
57185
I want to split a character string n by n. I know how to do that 1 by 1 :  \documentclass{article} \makeatletter  \def\s@plit&lt;#1#2&gt;{%   \ifx\empty#2%     #1%   \else     #1,\s@plit&lt;#2&gt;%   \fi}  \def\Split#1#2{\s@plit&lt;#2\empty&gt;} \makeatother  \begin{document} \Split{1}{123456789} \end{document}   It gives : 1,2,3,4,5,6,7,8,9  But I also want 1,23,45,67,89 or 123,456,789 ... depending from the first parameter.  EDIT  Work straight and reverse, even with foreach.        \documentclass{article}     \usepackage{tikz,xparse,xstring}  \DeclareDocumentCommand{\split}{smmo}{%     \xdef\Entree{#3}%     \let\Sortie\empty%     \IfBooleanTF #1     {% sans étoile         \loop         \StrRight{\Entree}{#2}[\tmp]%         \edef\Sortie{\Sortie,\tmp}%         \StrGobbleRight{\Entree}{#2}[\Entree]%         \unless\ifx\Entree\empty         \repeat         \StrGobbleLeft{\Sortie}{1}[\Sortie]%     }     {% avec étoile dans l'ordre inverse         \loop         \StrRight{\Entree}{#2}[\tmp]%         \edef\Sortie{\tmp,\Sortie}%         \StrGobbleRight{\Entree}{#2}[\Entree]%         \unless\ifx\Entree\empty         \repeat         \StrGobbleRight{\Sortie}{1}[\Sortie]%     }     \IfNoValueTF{#4}{\Sortie}{\edef#4{\Sortie}}     }  \begin{document} \split{2}{6513782}  \split*{2}{6513782}  \split*{2}{6513782}[\bob]  \foreach \x in \bob {[\x] }  \end{document}
59470
I am trying to remove the duplicates items from a big Excel sheet. I would like to remove all rows that have a duplicate code values (sample below)  Before:      Name     Code item_01  xxxx01 item_02  xxxx02 item_03  xxxx01 item_01  xxxx03 item_04  xxxx04   After:  Name     Code item_01  xxxx01 item_02  xxxx02 item_01  xxxx03 item_04  xxxx04   I have played with the "Remove Duplicates" features, but I can't get the result that I want.   Any help? Thanks