SOLVED

Excel Rows to columns

Copper Contributor

Hi, 

 

I need some help please from the experts here.

 

How do I get from A to B?

AJames007_0-1602759133638.png

 

2 Replies
best response confirmed by AJames007 (Copper Contributor)
Solution

@AJames007 

I'd do with Power Query - query the source; group by Item Number returning lists of Item Codes without aggregation; expand it columns; return result back to the sheet.

Ok, I get it. Thanks very much for your help :)
1 best response

Accepted Solutions
best response confirmed by AJames007 (Copper Contributor)
Solution

@AJames007 

I'd do with Power Query - query the source; group by Item Number returning lists of Item Codes without aggregation; expand it columns; return result back to the sheet.

View solution in original post