Extraction of table in Word, to be input into Excel as columns

[vrdabberu (Varunraj Dabberu)]

Hi @UIPYH

Check out this thread

Extract Data from Word Table to Data table or Excel

refering to the last screenshot following LINQ (taken from your post) Group p By FName=p.Item(“FacilityName”).ToString Into grp=Group Let ra= New Object() {FName, grp.Max(Function® CInt(r(“Beds”).toString.Trim)),grp.Sum(Function® Convert.ToDouble(r(“TotalCost”).toString.Replace("$","").Trim))} Select BedCount.Rows.Add(ra)).CopyToDataTable() and the reported output: FName1,124,2906.32 FName2,120,1859.19 is reasonable and within the expectation (2 Groups, 2 rows, Max, Sums) as it deriveable c…

Regards