Hi I need help with taking data from different rows and columns and putting them next to each other so is easy to capture. I have this mock-up example i got but it is what i need to do. I need to take the data colored in yellow and put it on a different row on a new sheet next to each other for e.g:
PIE45: Mutton Curry: R 9.90 R 2.58 R 8.68
Each one on a new column.
thats all i need to get from all the data there. but dunno the easiest way to retrieve it.
Any suggestions would be great.
Bookmarks