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

bpnelms's avatar
bpnelms
Copper Contributor
Aug 18, 2022
Maybe I missed it, but I don't see the different options in the file. Thanks
Lorenzo's avatar
Lorenzo
Silver Contributor
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

Resources