I have started using database and calc so most of attempts are trial and error and searching the web so sorry if this question seems out of wack.
Here is my situation. I have a calc spread sheet and I also created a table setup with about 50 columns and several hundred rows. I have a column with a list of studies then in the same row I have listed the various sources that are contained in that study. What I would like to do is perform a query of a particular source and see a list of all studies that used the same source. I have two problems I do not want to list all 50 columns for each query so it possible to combine the columns and is it possible to use input so with each query I can enter the search term only once.
Example of my headings. I would like to combine the columns SOURCE 1 to SOURCE 45, to eliminate writing them each time in a query and also the criteria the same number of times. I tried using " LIKE" for this purpose but received error messages. I have used :KEYWORD that works with a single entry is it possible to use across multiple columns as well?
Just additional some rows may contain only a few sources where others may contain 10 or more. Not sure if that makes a difference.
I am using Libre office Version: 5.1.6.2 Build ID: 1:5.1.6~rc2-0ubuntu1~xenial3 OS linux mint
ID NAME # PAGES AUTHOR SOURCE 1 SOURCE 2 SOURCE 3…SOURCE 45