Hi Team , I have a multi dimensional table, I want to convert that table into single -D table
This is the type of excel I’ll 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.
This is the type of excel I’ll 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.