Struxureware DCO Report exports with double spacing

[DCIM_Support]

Whenever we export SXW Ops Inventory Report and export it as EXCEL or CSV it introduces one row after each entry automatically. Now this becomes a problem for end customers who want to create analytics in excel since they first have to remove one row from each entry first and then start working ahead.

Any answers how we can resolve such a thing?

(CID:88211468)

[DCIM_Support]

Hi Vineet,

Blank lines are quite common when working with importing datasets in Excel,; fortunately excel contains tools that make it very easy to get rid of them. 

This is not really an excel forum - but I happen to know this method 😀

in Excel:

1. Select Column A (Must be a column where all the valid rows have data) 
2. In the excel menu system click -> edit/go to... 
3. Click "Special"
4. Select "Blanks" (Now a cell in each of the empty rows are selected)
5. On the Excel "home" tab under "Cells" click "delete rows"
6. Done.

(CID:88211503)

[DCIM_Support]

This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.