Hi All,
I have a huge data in a table and i want to get that data based on the parameters to another table... please help me with a best formula to use.
raw table as follows:
red green yellow
apple 2 5 7
capsicum 5 9 3
And my out put requirement as follows:
column 1 2 3 4 5
xxxx capsicum xxxxx xxxx red
yellow
green
red
so i need the output as if my column header is existing in the raw data and my row is matching then i need the number be appear in the respective cell.
Regards,
Vimala K
Bookmarks