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

[OlgaUA]

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

Thank you

[v-ljerr-msft · Accepted solution]

Hi @OlgaUA,

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

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]

Hello, everybody,

Thank you very much, everything turned out

[v-ljerr-msft]

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?

Regards

[Vvelarde]

@OlgaUA

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

[hugoberry]

In Query Edit try

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