+ Reply to Thread
Results 1 to 5 of 5

Generate Raw Data from Frequency Table

  1. #1
    Registered User
    Join Date
    04-15-2024
    Location
    Barrington, IL
    MS-Off Ver
    365
    Posts
    3

    Question Generate Raw Data from Frequency Table

    I would like to go from a 2d frequency table to a 2 column list with the given frequency. (Printing labels for each item) I need both the row and column header to be repeated X times.

    Sample Plant Sale data consolidation.xlsx
    Last edited by Arlona; 04-15-2024 at 05:46 PM.

  2. #2
    Registered User
    Join Date
    04-15-2024
    Location
    Barrington, IL
    MS-Off Ver
    365
    Posts
    3

    Re: Generate Raw Data from Frequency Table

    Attachment 866255

    Just incase it is easier to have a picture quickly.

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,064

    Re: Generate Raw Data from Frequency Table

    A picture rarely helps!! A sample file ALWAYS helps. Paste into any cell. No copy/paste needed.

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: Lá fhéile Pádraig sona dhaoibh

  4. #4
    Registered User
    Join Date
    04-15-2024
    Location
    Barrington, IL
    MS-Off Ver
    365
    Posts
    3

    Re: Generate Raw Data from Frequency Table

    Thanks so much! That is so incredibly helpful! I can't believe you solved it so quickly. I spent a few hours looking for the answer and this is all I was looking for. Thank you!!!!

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,064

    Re: Generate Raw Data from Frequency Table

    You're welcome. Thanks for letting us know that you got an answer.




    Please take a moment and consider clicking the "Add Reputation" button at the foot of any of the posts of anyone who helped you reach a solution here today.

    Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.

+ 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. Generate list based on value & frequency
    By ExcelNov2021 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-31-2021, 10:54 PM
  2. Excel generate random number with frequency
    By selman555 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-03-2012, 04:23 PM
  3. Replies: 4
    Last Post: 03-26-2012, 03:48 AM
  4. Generate a frequency table.
    By jebckr in forum Excel General
    Replies: 1
    Last Post: 04-04-2010, 03:31 AM
  5. What excel function to use to generate some words with a certain frequency?
    By pocketrocket in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-01-2008, 03:25 PM
  6. generate random numbers from a frequency list
    By adeina in forum Excel General
    Replies: 11
    Last Post: 06-21-2007, 11:34 AM
  7. generate output of numbers by frequency
    By cathal in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-18-2005, 06:06 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