Hi all,
There is probably a very simple solution to this but I have been pondering/experimenting for a few hours and can't seem to come up with anything so I figured I would reach out and see what you guys think.
Below is the Excel version of my process. The far left table is what my source data looks like (Module on the left with module owner's initials below). My finished product before transposing and matching names to initials etc. is shown on the right (an aggregated, period delimited, collection of all modules & corresponding owners that had a number above their module).
High level what tools would you guys recommend to do the following
1. Check each module cell 1-6 for a number (highlighted green). If there is it needs to grab the module letters (AP, Module #1-6, and permission level 0,3,4 etc.)
2. Text join to aggregate all the results into one.
Only solution I could think of would be adding 6 formula tools to search each column. I attached the file in case anyone is feeling generous enough to actually build something. All thoughts and ideas are welcome! Thank you so much!
