October 22, 2024
Chicago 12, Melborne City, USA
SQL

Please see the photo file because i am too difficult for this conversion. I want to convert data from row to column like this in SQL. Thanks all


FILE
ORIGINAL

I WANT IT’S

I want to convert the data behind the row into a column as shown in SQL. The problem becomes complicated when there are too many conditions so I cannot use Unpivot to satisfy the conditions. Please check the image I have described.



You need to sign in to view this answers

Leave feedback about this

  • Quality
  • Price
  • Service

PROS

+
Add Field

CONS

+
Add Field
Choose Image
Choose Video