Here's my problem;
I have a sheet with thousands of lines of data captured, eg:
A B C
ABC 1231 4321
PID M1234 H1234
OBR 98767 LEVO500
XYZ 5432 23456
I want to extract only those lines of data that have certain content in column A, in this case any lines that begin with "PID" or "OBR" I want to capture:
A B C
PID M1234 H1234
OBR 98767 LEVO500
Furthermore, I'd like to combine these output lines into one line, with or without the content of column A included.
Ideally, my output based on the above dataset would be:
M1234 H1234 98765 LEVO500
Suggestions are very much appreciated!
Thanks very much!
Bookmarks