I have six different conditions all being searched from the same dataset. I want to create a table that lines up the duplicate data and skips spaces for missing data.
I was able to copy the data from all six columns into one column and delete duplicate entries which created a master list of all possible entries. I have this and the row numbers on the left side in A and B. I was able to use a vlookup for the six other columns to return the row number that the data entry appears in.
The last part is where I'm not sure how to proceed. I want to make the six columns (12 when you include their row numbers) all be as long as the total list and the row numbers line up so that there are blank spaces when there is missing data. How can I move the text down to the appropriate row number?
I was able to copy the data from all six columns into one column and delete duplicate entries which created a master list of all possible entries. I have this and the row numbers on the left side in A and B. I was able to use a vlookup for the six other columns to return the row number that the data entry appears in.
The last part is where I'm not sure how to proceed. I want to make the six columns (12 when you include their row numbers) all be as long as the total list and the row numbers line up so that there are blank spaces when there is missing data. How can I move the text down to the appropriate row number?
