Log In
Register
Home
Active Member
March 12, 2019
Offline
Could you help me on this Transpose issue in excel
Have attached a sample data
There are two columns – Zone & Region
Now need to Transpose (or you may call something else also) – this data Horizontally – Zone wise
Under each zone – the respective Regions need to appear
Trusted Members
December 20, 2019
Offline
I am sure there is a funky, quicker way with power query, but this is a formula based answer
Copy the data in Column A then paste and remove duplicates, copy the result and paste/transpose across columns then under the first heading use the below formula (it is an array formula so will need entering using Ctrl Shift Enter)
=IFERROR(INDEX($B$3:$B$144,SMALL(IF(T$2=$A$3:$A$144,ROW($A$3:$A$144)-2),ROWS($T$3:T3))),"")
Copy across and down and you have the list under the headings
Purfleet
1 Guest(s)
