bpnelmsCopper ContributorAug 17, 2022SolvedTranspose 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...Show MoreLorenzo to bpnelmsAug 18, 2022bpnelms 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
Lorenzo to bpnelmsAug 18, 2022bpnelms 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
Lorenzo to bpnelmsAug 18, 2022bpnelms 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
Harun24HRBronze ContributorAug 17, 2022bpnelms If you want to go with formula then can try below. See the attached file.D2=UNIQUE(A2:A9)ThenE2 =TRANSPOSE(FILTER(B2:B9,A2:A9=D2)) unique_then_filter.xlsx11 KB
