Forum Discussion
Solved
Table format change using power query
Can anyone please guide me about a table alignment conversion using power query? Kindly see the excel file attached.
shohan421 Don't really know how that happened. See my version attached.
Edit: I see now. You didn't use the first row as headers.
shohan421 Select the first three columns (Manufacturer, Type and Country), right-click and choose "Unpivot other columns".