I have a number of text entries that are in a column but at different point/cells that have blanks between them. When the data refreshes, the entries change and so do the locations of the data; although it's still within a range within the same column. What I'm looking for is the formula that looks at a column and takes all of the text entries and lists them in sheet 2 in a single, list (no blanks).
Cells in Sheet 1 are in Column D and in Rows 4, 5, 8, 12, 14 and 18. What I'm looking for is in Sheet 2, Column D, the text on Sheet 1, is put in Rows 4, 5, 6, 7, 8 and 9 (single list).