Hello Forum
I could use some help figuring out a problem where I need to get some data into a different format for use by a certain program.
If you download the attachment, you will see an example of what I need it to look like in R5CL thru N.
The idea is to retrieve any values from column J if column I matches M5; and display those values, separated by a space, in a linear fashion, in cell N5.
This is just a sample of the data that will be converted, so manual(ie copy, paste, man. selection,etc..) actions won't help me much. I'm trying to automate it using formulas as much as possible.
Thanks in advance for your help!
Bookmarks