Results 1 to 9 of 9

Thread: Multi-dimensional table into single table in excel

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Multi-dimensional table into single table in excel

    Hi Team , I have a multi dimensional table, I want to convert that table into single -D table

    This is the type of excel Ill be working on
    In this select the column right next to the orange cell

    In which ever cell , if there is X value Select the corresponding row. Suppose If I select the column F since its the column right next to Orange color cell,
    I'll go for Row 6 and I'll select, Location 1,dsf,Neutral and fruit and paste it in a separate worksheets. Similarly next I'll go for column 6.

    Then I'll search for next Orange cell and column right next to it and continue this operation. how should I proceed.
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	ex-2.jpg 
Views:	15 
Size:	53.0 KB 
ID:	2585  
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts