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
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.
Attachment 866255
Just incase it is easier to have a picture quickly.
A picture rarely helps!! A sample file ALWAYS helps. Paste into any cell. No copy/paste needed.
Formula:Please Login or Register to view this content.
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
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!!!!
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks