Take a series of rows and break each row into multiple rows
Once again, I look to the Excel Gurus to assist. I have been stewing about this most of the day. I have rows of data and I need to take each row and some of its cells and produce a single row for each of the key cells. The heading is actually a key in a lookup table for XLOOKUP. There are a number of static fields as well. This sample shows the original output from a FILTER formula in the first 4 rows. Below that is the desired state.
Once again, I look to the Excel Gurus to assist. I have been stewing about this most of the day. I have rows of data and I need to take each row and some of its cells and produce a single row for each of the key cells. The heading is actually a key in a lookup table for XLOOKUP. There are a number of static fields as well. This sample shows the original output from a FILTER formula in the first 4 rows. Below that is the desired state. Read More