So here's what I'm trying to achieve: I have a table with info like so:
excel1.png
And what I want to do is, on a separate worksheet, automatically grab all row names with "TEST" in them and certain corresponding properties to make a new table:
excel2.png
Which ideally has some newly calculated cells in-between such properties.
What is the best way for me to go about this?
Bookmarks