+ Reply to Thread
Results 1 to 3 of 3

Any solution to arrange multiple data into a table in different spreadsheet?Example inside

  1. #1
    Registered User
    Join Date
    09-07-2017
    Location
    Malaysia
    MS-Off Ver
    2013
    Posts
    15

    Question Any solution to arrange multiple data into a table in different spreadsheet?Example inside

    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.
    Last edited by azrul94; 09-21-2017 at 12:28 PM.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Any solution to arrange multiple data into a table in different spreadsheet?Example in

    Hi azrul,

    I think if you do a Pivot Table with your data and have the repeats as the columns, using Sum for the values, you will get what you want.

    Time to learn more about Pivot Tables?

    Look at t his site:
    http://www.excel-easy.com/data-analy...ot-tables.html
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    09-07-2017
    Location
    Malaysia
    MS-Off Ver
    2013
    Posts
    15

    Re: Any solution to arrange multiple data into a table in different spreadsheet?Example in

    Thank you. I'm studying it and its working.
    TYVM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 09-08-2017, 12:47 AM
  2. [SOLVED] Extract Table from a Spreadsheet, arrange in various tabs and export to PowerPoint
    By vnzerem in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-27-2015, 08:11 PM
  3. How to arrange Data thanks to a Pivot Table
    By Yomdi in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 02-04-2015, 02:43 PM
  4. [SOLVED] Arrange data from table
    By atlant15 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-21-2012, 11:48 AM
  5. Using multiple SUMIF inside multiple IF stmts, looking for simpler solution.
    By thehotcorner in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-14-2012, 10:51 AM
  6. Replies: 4
    Last Post: 06-28-2011, 03:53 PM
  7. Replies: 9
    Last Post: 09-06-2005, 04:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1