A
Alex
I have a problem with copy and paste with filtered data.
I have a table with lots of data, about 20k rows.
Among this data, are different subsets of data, to exemplify:
Row 1 has all header infor for my actual data, however, for example row 2
will have a subset header.
Then row 3 - 15 has data acording to the headers in row 1
Then row 16 has a subset header, then row 17-126 has data. And so on and so
forth.
Now the problem here is, that the subset header is separated into three
cells, but it should only be one cell.
What I did was filter for the subset rows, then in a column after the last
one, I concatenaded the cells, unfiltered the data, selected the entire
column with concatenated data, and copy - paste special > values, to
eliminate the formula.
Now the problem is when I filter again on subset rows, and try to copy paste
the correct data, it will paste into the hidden rows, not into the visible
rows. It does copy only visible rows, but it pastes into the hidden rows. Is
there a workaround for this?
I have a table with lots of data, about 20k rows.
Among this data, are different subsets of data, to exemplify:
Row 1 has all header infor for my actual data, however, for example row 2
will have a subset header.
Then row 3 - 15 has data acording to the headers in row 1
Then row 16 has a subset header, then row 17-126 has data. And so on and so
forth.
Now the problem here is, that the subset header is separated into three
cells, but it should only be one cell.
What I did was filter for the subset rows, then in a column after the last
one, I concatenaded the cells, unfiltered the data, selected the entire
column with concatenated data, and copy - paste special > values, to
eliminate the formula.
Now the problem is when I filter again on subset rows, and try to copy paste
the correct data, it will paste into the hidden rows, not into the visible
rows. It does copy only visible rows, but it pastes into the hidden rows. Is
there a workaround for this?