If you're like me you get excited when there is a challenge with a formula or process. Well. I am stumped. And I could use the collective knowledge of people here.
I have a spreadsheet where there are two rows which provide details to everything beneath it (Example: I2 is "cost") and the "details" from E6 until xldown is aligned to the "cost" e2. That is "easy" enough. However, "cost" can repeat an "x" number of times with the "details" below x number of times. I am at a loss on how to make this work.
I have a spreadsheet where there are two rows which provide details to everything beneath it (Example: I2 is "cost") and the "details" from E6 until xldown is aligned to the "cost" e2. That is "easy" enough. However, "cost" can repeat an "x" number of times with the "details" below x number of times. I am at a loss on how to make this work.