Forum Discussion

bpnelms's avatar
bpnelms
Copper Contributor
Aug 17, 2022
Solved

Transpose or ??

This is probably a simple thing, but I haven't found anything that works.  It's similar to transpose, but not really.  So basically I need the table on the left of the screenshot converted into the t...
excel
Formulas and Functions
  • Lorenzo's avatar
    Lorenzo
    Aug 18, 2022

    bpnelms 

     

    I only loaded Option1 to the sheet. All others are Connections only. To load them to sheets:

    - Go to the Data tab > Queries & Connections (the corresponding pane opens)

    - Right-click on each where you see Connection only below its name > Load To... > Table > OK

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Aug 17, 2022

bpnelms 

It depends on your Excel version / platform. Perhaps Power Query is preferable solution if you have few thousand rows of data. For Excel 365 dynamic arrays formulae could work, but that again depends on version.

 

So, to be more concrete it's desirable to know on which excel you are.

bpnelms's avatar
bpnelms
Copper Contributor
Aug 17, 2022

SergeiBaklan I am using a windows PC with Office 365. I’m somewhat familiar with Power Query but just didn’t know where to start. 

Resources