Snippet for Pratik

{note: preview=no}
{webdata={site: text; selector=#resultTab1 > tbody}}
{endnote: trim=right}

{note: preview=yes}
Paste your data here:
{formparagraph: name=sampledata; cols=80; rows=20; default=
CIN U51909MH2020PTC338144
ROC Code RoC-Mumbai
Registration Number 338144
Company Category Company limited by Shares
Company SubCategory Non-govt company
Class of Company Private
Authorised Capital(Rs) 2500000
Paid up Capital(Rs) 2500000
Number of Members(Applicable in case of company without Share Capital) 0
Date of Incorporation 24/02/2020
Registered Address 509,510 & 511, ATLANTIC COMMERCIAL TOWER PATEL CHOWK, R. B. MEHTA MARG GHATKOPAR (E), MUMBAI Mumbai City MH 400077 IN
Address other than R/o where all or any books of account and papers are maintained -
Email Id
Whether Listed or not Unlisted
ACTIVE compliance
Suspended at stock exchange -
Date of last AGM -
Date of Balance Sheet -
Company Status(for efiling) Active

{endnote: trim=right}

{note: preview=no}
{rawdata=sampledata} <= In here, change sampledata to rawdata if you want to use the selector method.
{rows=split(rawdata, "\n")}
{data=map(rows, item -> split(item, "\t"))}
{items=[row[1]=row[2] for row in data]}
{endnote: trim=right}

Dropdown to get the data in the second column for the chosen row:
{formmenu: name=col1value; values={=keys(items)}}: {=items[col1value]}

List of values (without keys) separated by commas:
(Sheets won't let you paste into multiple cells, but you can paste this data into a single cell and then use the split function in sheets to break it up into multiple columns)
{=join([row[2] for row in data], ", ")}

1 Like