Search:

Type: Posts; User: dankar; Keyword(s):

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Re: Converting specific columns to vertical one record

    I already posted it in this link but no one gave a correct answer,its ok to use Excel.

    sorry to bother you again.

    I noticed in my data result that there is another field that have different...
  2. Re: Converting specific columns to vertical one record

    I'm really grateful for your help.

    Surly I will read the links you sent, but the issue for now that I need to show the result tomorrow.

    I already tested the adding more columns before I see...
  3. Re: Converting specific columns to vertical one record

    the excel table was exported from access query.(contains the main columns I need)
    I was asking if I created a bigger table which included these columns and another ones also.

    I will use your...
  4. Re: Converting specific columns to vertical one record

    thank you for the links.
    I have one more question plz.
    If I want to add more columns to your code, I need to type the column name for each one in {"COLUMN NAME", type text} or there is another way...
  5. Re: Converting specific columns to vertical one record

    Thank you sooo much! worked perfectly !
  6. Re: Converting specific columns to vertical one record

    sorry for the inconvenience.

    I fixed the hears, I look silly with this..where shall I insert "Table1" to name the table :

    Expression.Error: We couldn't find an Excel table named 'Table1'....
  7. Re: Converting specific columns to vertical one record

    thank you and sorry for that!

    I went though the steps and I got the following although "'FILE NO" is there:

    Expression.Error: The column 'FILE NO' of the table wasn't found.
    Details:
    FILE...
  8. Re: convering spicific coulmns to vertical one record

    thank you for your reply and help.

    will yo please explain how to apply it.

    do I need to type table1 in a specific cell before the table. Thank you again
  9. Converting specific columns to vertical one record

    I have similar to this table with many columns and thousand of rows (patients)

    - as you can see each patient have 6 tests(test1 to test6) with different 6 result.
    - all other columns have the...
  10. Re: switching specific coulmns from vertical to horizantal to get one record !

    It's a query from view tables
  11. switching specific coulmns from vertical to horizantal to get one record !

    I have similar to this table with many columns and thousand of rows (patients)

    - as you can see each patient have 6 tests(test1 to test6) with different 6 result.
    - all other columns have the...
  12. Re: Moving the columns from horizontal to vertical

    Thank you all so much!
  13. Moving the columns from horizontal to vertical

    <tbody>
    ID

    FIRST NAME

    LAST NAME

    DATE

    PHONE#
  14. Replies
    1
    Views
    336

    updating three columns

    <tbody>
    A

    B

    C



    E1
  15. Thread: date question

    by dankar
    Replies
    3
    Views
    233

    Re: date question

    Thank you so much
  16. Thread: date question

    by dankar
    Replies
    3
    Views
    233

    date question

    <tbody>

    original date

    collection date



    1
  17. Re: adding border line after the same id number

    Thank you a lot, worked perfectly!
  18. adding border line after the same id number

    <tbody>

    ID number

    B

    C

    D
  19. Replies
    9
    Views
    215

    Re: merging data in one row

    Thank a lot for your help..problem solved.
  20. Replies
    9
    Views
    215

    Re: merging data in one row

    Sorry for bothering you..

    i made the change and i got this :

    Run-time error '13':
    Type mismatch

    and a new blank sheet was created
  21. Replies
    9
    Views
    215

    Re: merging data in one row

    Sorry..

    it worked but I noticed that it gave only the first 5 columns.

    I have 14 column (from A to N) and 270 row.

    I thought the code will just take the second raw and put it in te end of...
  22. Replies
    9
    Views
    215

    Re: merging data in one row

    Thanks for your help.

    wen am applying the code am getting this:
    "There's already data here. Do you want to replace it?"

    how can I get the result in new sheet? thank you
  23. Replies
    9
    Views
    215

    merging data in one row

    <tbody>
    ID


    Part number

    Kind

    manf. date
  24. Replies
    5
    Views
    259

    Re: Highlighting all the blank fields

    no Formula in the cells.
    when I tried len(G1) TO len(M1) and going down. all the results is 0
  25. Replies
    5
    Views
    259

    Re: Highlighting all the blank fields

    Thanks for your reply..

    it didn't work with me.

    FYI,I tried to find & select>Go to special> Blank and the result was: no cells were found although there a lot of blank cells.
Results 1 to 25 of 71
Page 1 of 3 1 2 3