Forum Discussion
Extracting data from a table with merged cells
Dear Excel Community I'm trying to extract data from a table with merged cells into a new table (that doesn't include merged cells). This is an extract of the table I want to extract data f...
I had to go to something a little more elaborate because I did not have the cell merging in both columns.
= LET(
topics, FILTER(topic, topic<>""),
criteria, FILTER(criterion, criterion<>""),
HSTACK(topics, criteria)
)