I have one excel file that has multiple sections of data. I need to only bring in certain parts of each section. in the picture (i have also attached excel file), I only want the green sections. how would I go about this?
Thank you!
Solved! Go to Solution.
Hi @aberry0613
You can check if the second column [end] is null or not. If it is null, then filter the data out.
Its always something so easy when i think it is going to be complicated. :-)
Thank you @adm510 !
OK, so what about this. I need the software now listed as a column for each entry. I have color coded the Visio tab to match what I need the out put to look like (sheet 1). Basically, I need to take the software title and make it a column for all entries under it until the next section of data.
Thanks
Thank you! I love learning about new tools.