Sep 20 2022 08:56 AM - edited Sep 21 2022 09:03 AM
EDIT: had issues adding images so i uploaded them to a hosting site. The first image, what my worksheet currently looks like: https://ibb.co/yXR1jmb
What i would like it to look like: https://ibb.co/s1n4yhP
UPDATE: The excel worksheet with sample data Sample Data Sheet
Sep 20 2022 08:59 AM
@Kenechukwu_Oraelosi hello, I do not see either of the pics mentioned attached. Please kindly provide so that the community can visualize your intent.
Thank you,
Dexter
Sep 20 2022 09:01 AM
Sep 20 2022 09:08 AM
you should be able paste (or drag & drop as shown below) directly into these message boxes.
Sep 20 2022 09:11 AM
Sep 20 2022 11:34 AM
Sep 20 2022 12:08 PM
The quick and dirty way to accomplish this with one formula (Requires Excel 365) is:
=CHOOSECOLS(HSTACK(TRANSPOSE(MOD(SEQUENCE(3,ROWS(A1:C28),1,1)-1,ROWS($A$1:$C$28)))+1,A1:C28),{4,1,5,2,6,3})
I know there's a way to clean this up and account for the different range sizes but wanted to get something to you which was directionally correct to get you started.
Sep 20 2022 12:15 PM
Sep 20 2022 12:29 PM
@Kenechukwu_Oraelosi Thanks for the clarification. I'll unfortunately have to defer to one of the other community experts knowledgeable with legacy arrays. Excel 365 makes these array formulas so much easer that even I can grasp them. :)
Sep 20 2022 12:39 PM