Hello, Kindly help me. What formula to use or how to transform my wide data to long ? In the photos below, I made it through manual input. This will be time consuming if I have large data. Thank you in advance so much!
From
Wide to long.PNG
To
Wide to long 2.PNG
Select the data, goto Data>Get & Transform>From Table/Range.
In Power Query right click the Acronym column header and select Unpivot Other Columns.
Click Close & Load.
If posting code please use code tags, see here.
Hi,
See if that works for you:
I3 = =A2
I4 and down =IF(J4="","",IF(ISBLANK(INDEX(A:A,MATCH(I3,A:A,0)+1)),$I$3,INDEX(A:A,MATCH(I3,A:A,0)+1)))
J3 and down =IFERROR(IF(COUNTIF($J2:J$3,J2) < COUNT($B$2:$B$7),J2,INDEX($B$1:$E$1,MATCH(J2,$B$1:$E$1,0)+1)),"")
K3 and down:
=IFERROR(INDEX($B$2:$E$7,MATCH(I3,$A$2:$A$7,0), MATCH(J3,$B$1:$E$1,0)),"")
Last edited by Limor_OP; 09-20-2020 at 01:50 PM.
Thank you so much for this. Appreciate it!
Thank you so much for this. Helped me a lot.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks