Forum Discussion

OlgaUA's avatar
OlgaUA
Frequent Visitor
9 years ago
Solved

How to create a simple new table with two columns: ID (count) and value?

I can not find formulas, descriptions ..
Is it really only an import?

Thank you

Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi OlgaUA,

     

    Both solutions provided above can create a simple new table in your scenario.:smileyhappy:

     

    1. Click Get Data -> Choose Blank Query, then Enter the formula below.

    =#table({"ID","Value"},{{1,"A"},{2,"B"}})

    2. Click "Enter Data" under Home tab, then you should be able to input/paste your table there.

     

    Regards

5 Replies

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi OlgaUA,

     

    Both solutions provided above can create a simple new table in your scenario.:smileyhappy:

     

    1. Click Get Data -> Choose Blank Query, then Enter the formula below.

    =#table({"ID","Value"},{{1,"A"},{2,"B"}})

    2. Click "Enter Data" under Home tab, then you should be able to input/paste your table there.

     

    Regards

    • OlgaUA's avatar
      OlgaUA
      Frequent Visitor
      9 years ago

      Hello, everybody,

      Thank you very much, everything turned out

      • v-ljerr-msft's avatar
        v-ljerr-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        9 years ago

        Hi OlgaUA,

         

        Great to hear the problem got resolved! Could you accept helpful replies as solution to help others who may also have the similar issue easily find the answer and close this thread?:smileyhappy:

         

        Regards

  • hugoberry's avatar
    hugoberry
    Icon for Responsive Resident rankResponsive Resident
    9 years ago

    In Query Edit try

     

    =#table({"ID","Value"},{{1,"A"},{2,"B"}})