I have a financial spreadsheet of approximately 5000 rows. It has line(s) of costs with the parent entity at the bottom. A line skips and then it goes to the next line(s), etc.
What I want to do is have that parent entity to the right of the cost designations but then start anew when the next section comes up. I've wracked my brain and my Jelen book but I'm not getting what I want.
Any thoughts?
Below the "What I want" are new rows, maybe Franklin & C, maybe another company and with a varying amount of lines above it for the lines of financials.
If I only had a hundred rows, I could force it through and be done. However, looking to learn for long-term and also solve this much faster than a copy/paste back and forth mumbo jumbo for 5000+ rows of data.
What I want to do is have that parent entity to the right of the cost designations but then start anew when the next section comes up. I've wracked my brain and my Jelen book but I'm not getting what I want.
Any thoughts?
Below the "What I want" are new rows, maybe Franklin & C, maybe another company and with a varying amount of lines above it for the lines of financials.
If I only had a hundred rows, I could force it through and be done. However, looking to learn for long-term and also solve this much faster than a copy/paste back and forth mumbo jumbo for 5000+ rows of data.