Dear all,
Im sorry, Im new in using microsoft excel. My excel ver is 2013.
Forgive me if im using the incorrect term for Excel.
I have a problem to solve a thousands of data that i need to assign it accordingly into a table from a different spreadsheet (speadsheet a and b) which consuming a lot of time. The example are as shown:
Spreadsheet a
type repeats occurences ac 4 122 ac 5 123 ac 6 23 ac 7 21 at 4 233 at 5 123 ta 4 321 cat 4 231 cat 6 111 tca 8 231
Every information in spreadsheet a are needed to be assign into the table in spreadsheet b accordingly as shown below ("repeats/occurrence" should be merge; sorry, I don't know how to merge it here).
Spreadsheet b
type repeats/occurences repeats/occurences repeats/occurences repeats/occurences repeats/occurences 4 5 6 7 8 ac 122 123 23 21 at 233 123 ta 321 cat 231 111 tca 231
I tried to search videos or information to solve it, however i couldn't find any solution related to my problem. Can anyone help me out?
Thank you for helping.
Bookmarks