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

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
9 years ago

OlgaUA

 

Hi, you can create a new table using "Enter DATA" Option.