Ok, I've been searching different forum posts and am nearing wits end...
I've got a workbook in which in attach workbook, sheet1, column B is actually data pulled from a larger sheet via a pivot table. Actually multiple pivot tables in succession. I know what my arbritary number of total lines will be for any given table so can accommodate for that. What I need to do is the following.
Sheet1 has parsed data. I need to build a new sheet from this data with only the valid lines. Need to skip the zeros. I need to leave the "0" in the lines on sheet1 for when the master table is updated it will then poplulate those lines which will then be seen by the formula and populate onto the sheet2 tab.
In attachment, sheet 1 is data, sheet2 is what it needs to look like. There are many more columns of data which will be populated via vlookups from the increment in column 1. On sheet 1, columnA is a count identifier from columnB whereas =if(B2=0,0,A1+1) ColumnD and so on contain multiple columns of data relating to an instance of columnB as the number in columnB may be repeated more than once.
Sorry, clear as mud right...
Need to get actual data from sheet1(has a number identifier in A, no "0" values) to sheet2
Bookmarks