0

I'm trying to create a business 'calendar' in a specific format: weeks down the side, categories across the top. I have the data in a flat format but cannot work out how to translate it.

I've tried thinking in terms of INDEX, MATCH, OFFSET etc but can't get my head around it.

Are there any whizzes out there who can help, please? I'm usually quite good at this stuff but perhaps I'm having a mental block.

Basically I'm trying to get from the table on the left to the table on the right. What formula can I use in the yellow cells?

Thanks in advance!

enter image description here

Improve this question
3
  • You haven't done me any by not telling me what the alternative is? Am new to this!
    – ChrisD
    Commented Jun 19, 2018 at 17:26
  • Also, you are not doing yourself any favors with lack of clarity...what is your goal in the transition? What is the purpose of the letters in table 1? Also, are you, "...usually quite good..." or, "new to this?"
    – Sam
    Commented Jun 19, 2018 at 17:33
  • New to this website...
    – ChrisD
    Commented Jun 19, 2018 at 18:09

1 Answer 1

Reset to default
1

Enter as an array formula in Q2:U11 (ctrl+shift+enter):

=TRANSPOSE(IF(LEN(C2:L6)=0,"",B2:B6))
Improve this answer
2
  • Thank you - I will try this shortly and let you know. I've not used TRANSPOSE before... intriguing.
    – ChrisD
    Commented Jun 19, 2018 at 18:13
  • Amazing... I really need to get my head around CSE functions. Very concise and works perfectly - thank you jblood94
    – ChrisD
    Commented Jun 20, 2018 at 7:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.