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?
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
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.
Hi Vinay,
No workbook attached. You need to click on Start Upload.
Phil
Hi,
kindly check now
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)
Hi sir,
Thank you so much.
it solved the problem.
