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

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