Partially transpose a table

Question

Hi fellow Excellers,&nbsp;I am dealing with a table that I want to partially transpose. See table I below as an example. I want to include the weeks in the rows (see table II). I can't figure it out, can someone help me?&nbsp;Cheers!&nbsp;BrandModelColourWeek 1-2023Week 2-2023Week 3-23AppleS32022Black100013911708Apple13 PROBlack134167195Apple8White397413651SamsungS20Black537856895290SamsungS10Black809881348123SamsungS10eBronze625466376587SamsungS8White426481443NokiaG21Black129176198Nokia210Black753276127751Table I&nbsp;BrandModelColourDateAppleS32022Black1000AppleS32022Black1391AppleS32022Black1708Apple13 PROBlack134Apple13 PROBlack167Apple13 PROBlack195Apple8White397Apple8White413Apple8White651SamsungS20Black5378SamsungS20Black5689SamsungS20Black5290SamsungS10Black8098SamsungS10Black8134SamsungS10Black8123SamsungS10eBronze6254SamsungS10eBronze6637SamsungS10eBronze6587SamsungS8White426SamsungS8White481SamsungS8White443NokiaG21Black129NokiaG21Black176NokiaG21Black198Nokia210Black7532Nokia210Black7612Nokia210Black7751&nbsp;

hansvogelaar · Accepted Answer

PBrabander&nbsp;
Click in the source range.
On the Data tab of the ribbon, in the Get &amp; Transform Data group, click From Table/Range.
Select all the week columns.
In the query editor, activate the Transform tab of the ribbon.
Select Unpivot Columns &gt; Unpivot Only Selected Columns.
If you don't want the week in the final result, right-click the column with the weeks and select Remove from the context menu.
Switch back to the Home tab of the query editor, and click Close &amp; Load.
&nbsp;

Forum Discussion

Partially transpose a table

Share

Resources

Brand	Model	Colour	Week 1-2023	Week 2-2023	Week 3-23
Apple	S32022	Black	1000	1391	1708
Apple	13 PRO	Black	134	167	195
Apple	8	White	397	413	651
Samsung	S20	Black	5378	5689	5290
Samsung	S10	Black	8098	8134	8123
Samsung	S10e	Bronze	6254	6637	6587
Samsung	S8	White	426	481	443
Nokia	G21	Black	129	176	198
Nokia	210	Black	7532	7612	7751