HOW TO TRANSPOSE BOM AUTOMATICALLY IN SOLIDWORKS?

FOR EXAMPLE

ITEM NO     DESCRIPTION     MATERIAL     QTY.

1                    NOZZLE                                  1

2                    FLANGE                                 1

3                    BOLT                                      4 

4                    NUT                                        4

5                    GASKET                                 1    

NEW bom needs transposed like,

ITEM NO               1       2       3       4       5

DESCRIPTION     .......................................

MATERIAL.................................................

QTY..........................................................

Thanks first