How to convert rows to column in MS SQL as per below example

Asked May 09 '22 at 08:03

Active May 09 '22 at 08:14

Viewed 29 times

-1

Zone	product	Primary_sale	Secondary_sales
North	MS	4000	1000
North	HSD	5000	2000
East	MS	6000	3000
East	HSD	7000	8000

MS SQL code to convert above data to as below

Zone	MS_primary_sale	MS_secondary_sale	HSD_primary_sale	HSD_Secondary_sale
North	4000	1000	5000	2000
East	6000	3000	7000	8000

edited May 09 '22 at 08:04

Zhorov

asked May 09 '22 at 08:03

The_learner

Have you tried anything? There are a zillion examples of this online. – Nick.McDermaid May 09 '22 at 08:12
I've added a couple of duplicates, but there are *literally* 100's. If you have read, and tried to implement said duplicates, then [edit] your question to show your attempt(s) and explain why they don't work. If you didn't understand the answers, then link and cite the answers you didn't understand and **describe** what about those answers you didn't follow, so we can elaborate. – Larnu May 09 '22 at 08:15

0 Answers0