u/oneworrytoomany

So this is a doozy. I have about 60 word files on a SharePoint site. Each of the word files is a table, similarly formatted, with similar columns. My goal is to get the data within the columns into an excel file.

The tables are formatted in such a way that when you paste into excel, sometimes it is pasted into multiple rows when it’s not immediately clear that would be the case in the word file.

Ultimately the last column is something like languages and lists all the different languages related to that row.
What I want to happen is split that out into excel so each language is on its own row.

Is there any better way than manually going through all the files, pasting, taking the overflow into the next rows down into the cell above (essentially unmerging the cells), and pulling out each language into its own row?

I’ve tried a =TRIM( and a =TRANSPOSE(TEXTJOIN( but it is still cumbersome and doesn’t work all the time. Plus, ideally could assign a chunk of files out to other people and they would not have the same proficiency with formulas as me.

Any help or advice is appreciated! Thanks!!

Hey y’all,

I know lots of you are grieving the loss of Mr King and all he has meant to the Bulls and to each of us.

A friend of mine, who grew up with his sons, has created a Facebook group to post tributes, stories, fond memories, well wishes for his sons and his family to have and see and look back on.

It’s not much but if you’re feeling like posting something, I’m sure it would mean a lot to his friends and family.

Sorry if this isn’t allowed, but I wanted to help spread the word.

We miss you Stacey!

Anybody know what’s with the 2 police helicopters hovering around the Jefferson Park Blue line this evening?