Hi,
I am trying to take string data from multiple sheets that is listed in the same row each time, and summarise it in a column (or row), while removing any gaps. There may be a quite obvious fix, but I have found no solution.
So I have data that looks like this:
Sheet 1
<tbody>
</tbody>
Sheet 2
<tbody>
</tbody>
...
etc.
And would like to then on my final sheet (let's say I only have 2 sheets of data and one final 3rd sheet) a summary of everything from the specific shown row, excluding any gaps e.g.:
Sheet 3
<tbody>
</tbody>
Would this be possible? Any help is appreciated!
I am trying to take string data from multiple sheets that is listed in the same row each time, and summarise it in a column (or row), while removing any gaps. There may be a quite obvious fix, but I have found no solution.
So I have data that looks like this:
Sheet 1
A | B | C | D | E | |
1 | Cow | Chicken | Barn |
<tbody>
</tbody>
Sheet 2
A | B | C | D | E | |
1 | Pig | Sheep |
<tbody>
</tbody>
...
etc.
And would like to then on my final sheet (let's say I only have 2 sheets of data and one final 3rd sheet) a summary of everything from the specific shown row, excluding any gaps e.g.:
Sheet 3
Summary |
Cow |
Chicken |
Barn |
Pig |
Sheep |
<tbody>
</tbody>
Would this be possible? Any help is appreciated!