Posts by fizza94

    Re: Add/Delete Extra Spaces Per Cell

    I still want one space between each column header, not eliminate all spaces. Trim allows to delete spaces before and after the text ends but I still might have 2 or 3 spaces between each column header.

    For example, if only A2 and D2 are yes, I would have 3 spaces between the column headers.


    Attached is a sample of the data I have created. For the 6th column, I have concatenated the appropriate column headers I need, except I want a space in the middle of each of them, if they are put in the system. I have used the simple method of adding a space between each column header, however, i need the space ONLY between 2 column headers, if and when they are added the 6th column. This is what the formula in the 6th column currently says:

    =CONCATENATE(IF(A2="YES",$A$1,""), " ",IF(B2="YES",$B$1,"")," ",IF(C2="YES",$C$1,"")," ",IF(D2="YES",$D$1,""))

    However, there are multiple problems with the spacing. I have attached a sample table for an example.

    Please let me know how i can remove any spaces in front of the very first column header (text) or more than one spaces between 2 column headers (text). thank you!

    Re: Display A,B,C and/or D based on rows in front

    That is exactly what I was looking for! Thank you for the easy fix!

    Quote from mohammedismail;766104

    From what I have understood, I believe this is what you are looking for ! Please respond if not !



    I have 4 columns with different combinations of yes or no in each row. For the 5th column, I need it to display A,B,C or D, depending on what column has 'Yes' in it. I can construct a long IF function but there are ~16 or so combinations. What is the best method to this? Attached is a sample excel file of the sample of the data.

    Thank you!


    I have a 800 page long table that needs to be transposed from rows to columns. For easiness, I assigned a unique number to each person's assigned information, however, I cannot find a simple solution to my problem still, for easily moving each person's information from rows to columns.

    Currently my excel data looks like this:
    A B
    1 tim
    1 300 ave
    1 woodland hills, CA
    1 (123) 456-7890
    2 tam
    2 400 ave
    2 stockton, CA
    2 (123) 456-7890
    2 (123) 456-7890
    3 bob
    3 bobi ave
    3 hills, CA
    3 (321) 654- 9870

    and I need the data to look like this:
    A B c D E F
    1 tim 300 ave woodland hills, CA (123) 456-7890
    2 tam 400 ave stockton, CA (123) 456-7890 (123) 456-7890
    3 bob 500 ave hills, CA (321) 654- 9870

    Please help! I have been stuck on this problem for 3 weeks now and can't seem to find a simple solution :(

    Thank you!