如何基于行号动态创建新列

我在表上创建了一个查询，如下所示：

WITH CTE_count
as
(
 select Customer_ID as ID,Brand_Name +'-'+ cast([Sale_Amount] as nvarchar) as 
 brandname,ROW_NUMBER() OVER (PARTITION BY Customer_ID ORDER BY Customer_ID)
 AS lineNumber
 from dbo.sheet1
 group by Customer_ID,Brand_Name,[Sale_Amount]
)
 SELECT ID, brandname,lineNumber
 FROM CTE_count;

当我运行它时，我得到以下输出：

现在如何为每个客户ID获得1行，例如：

cust_id order1 order2 order3 order4 100000443 AMANA-71.31 AMANA-104.4 AMANA-109.89 AMANA-104.4

如何修改以上查询

我想对每个给出该示例的行的每个ID进行此操作