Forum

Notifications
Clear all

Transpose with sorting

7 Posts
3 Users
0 Reactions
337 Views
(@vinayragbotra)
Posts: 4
Active Member
Topic starter
 

Hi, I don't know how to make this understandable.

I want to transpose two columns by sorting or filtering the by type of something. check the attachment for a better understanding.

How to do this using formula?

 
Posted : 23/10/2020 3:05 pm
(@purfleet)
Posts: 412
Reputable Member
 

What version of excel are you using? it could make a huge difference to the complexity

Also, please add an exmaple workbook rather than a picture so we not have to recreate the data

 
Posted : 24/10/2020 4:15 am
(@vinayragbotra)
Posts: 4
Active Member
Topic starter
 

Hi, 

Thank you so much for the response.

I am using office 365 and google sheets sometimes.

I have attached the workbook with sample data.

 
Posted : 24/10/2020 7:34 am
Philip Treacy
(@philipt)
Posts: 1632
Member Admin
 

Hi Vinay,

No workbook attached. You need to click on Start Upload.

Phil

 
Posted : 24/10/2020 7:48 am
(@vinayragbotra)
Posts: 4
Active Member
Topic starter
 

Hi, 

kindly check now

 
Posted : 24/10/2020 7:58 am
(@purfleet)
Posts: 412
Reputable Member
 

Using Office 365 make it really easy, transpose & unique to get the headers then filter for the results

=TRANSPOSE(UNIQUE(A2:A7))

=FILTER($B$2:$B$7,$A$2:$A$7=K$1)

 
Posted : 24/10/2020 9:47 am
(@vinayragbotra)
Posts: 4
Active Member
Topic starter
 

Hi sir, 

Thank you so much.

it solved the problem.

 
Posted : 24/10/2020 1:54 pm
Share: