• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Structuring Data (Visualising)

AAP

Member
Hi,
I have data which is in Range(A1:D50) in the attached workbook.
But I want to visualise or sturcture data in the format in the same sheet Range(F1:W4).
Can anyone help how can I structure this kind of data.
I don't mind if need to use VBA or formulas or PowerPivot.
Many thanks for help.
 

Attachments

  • TEST.xlsx
    12.8 KB · Views: 4
Or another formula option but without helper

In H7, copied across and down :

=IFERROR(VLOOKUP($F7&$G7&H$6,IF({1,0,0,0},INDEX($A$2:A$48&$B$2:B$48&$C$2:C$48,0),$A$2:D$48),4,0),"")

Regards
Bosco
 

Attachments

  • TEST(Vlookup).xlsx
    16.9 KB · Views: 11
Or another formula option but without helper

In H7, copied across and down :

=IFERROR(VLOOKUP($F7&$G7&H$6,IF({1,0,0,0},INDEX($A$2:A$48&$B$2:B$48&$C$2:C$48,0),$A$2:D$48),4,0),"")

Regards
Bosco

Your solution worked even more quickly. Genius!!!
Many many thanks
 
Back
Top