I’m trying to add categories to a list in an excel(datatable) based on previous values. Essentially I’m trying to process my “daily” activities that are sequentially listed in an email. I have everything working and can get the values out into excel. Last challenge is to get the right section/category. The items in bold are always the same, and I want them to list in column three until column 4 has the next bolded phase. Currently, I’m looping through datatable to “build” columns 1,2,4.
Desired output is to fill in column 3.
Any ideas would be much appreciated, trying to have the bot do a timesheet.