Hi I have a table below where Item is repeated for type Parts and servicezwnj Item Type CostOfSales Quantity11827350 Parts 115 211827350 Service 5880235 255933075 Parts 725 155933075 Service 228 360326154 Parts 675 460326161 Parts 0292 160327210 Parts 625 160427220 Parts 575 160427220 Service 370343 164726175 Parts 18 264726175 Service 24 2Bzwnjut i need to display itemNo once and cost of sales and quantity for Parts and Service in one line as belowNo PCostOfSale

Hi sthsyedRefer below linkUse multiple aggregate columns in pivot query in SQL Server

Convert multiple columns into rows using Pivot query in SQL Server

sthsyed

Hi , I have a table below where Item is repeated for type Parts and service.
‌

B‌ut i need to display itemNo once and cost of sales and quantity for Parts and Service in one line as below.

‌Thanks

dharmend...

0 1

Refer below link.

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html