Dear Excel Pro's,
Could You please, help me with transforming my data from A) form to b) form,
photo_2018-06-12_18-54-41.jpg
Thank You
Dear Excel Pro's,
Could You please, help me with transforming my data from A) form to b) form,
photo_2018-06-12_18-54-41.jpg
Thank You
Last edited by tta.akmal; 06-12-2018 at 10:04 AM. Reason: more information
Bit of overkill on your part since the values below 5610 and 4310 are the same, and that pattern follows throughout the table
Nevertheless
in L2
=INDEX($C3:$C1000,(COLUMN()-12)*5+1,1)
and copy across the row
in K3
=INDEX(B$3:B$1000,(ROW()-3)*5+1,1)
and copy down
in L3
=IF(L$2=INDEX($C$3:$C$1000,(ROW()-3)*5+1,1),INDEX($C$3:$C$1000,(ROW()-3)*5+2,1),"")
and copy across and down
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks