•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to prepare a table that displays two rows of data
Our take
Struggling to transform your data from an outdated Word document into a concise table? You're not alone. Preparing a table that effectively displays two rows of data can be challenging, especially when dealing with lengthy text. By leveraging Excel’s capabilities, you can create a more organized layout, allowing one cell to hold up to 200 characters on its own row while keeping the rest of the data aligned below.
I am tasked with finding an automated way to display a list of cases as a means of replacing an older Word document. After exporting the data into Excel, I'm stumbling on how to prepare the data to display on two rows. Considering that one cell can be up to 200 characters long, having it on its own row while the remaining data stays on the second row would display more concisely compared to trying to have the entire row display on a legal sized sheet of paper.
My search hasn't been very helpful mainly from not knowing the right terminology. I've found various tutorials on how to create two rows for headers and those aren't helpful. It looks like a pivot table won't do the trick. I've looked at finding ways to display two formulas on a single cell with an alt+enter to fake a second row, but finding out that word wrap has to be on completely breaks any chances of that. The included screenshot is a shortened example of what I'm trying to go for.
Any recommendations on where to proceed? Thank you in advance. Experience level is "learn as I'm assigned tasks" which has been working well enough thus far.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- How to organize a sheet based on how many times a certain value in a column is duplicated, and have all other columns follow?Hope the title is descriptive enough... i feel like i always struggle to describe excel stuff efficiently. I am a complete excel beginner! So i have a dataset that is 3000+ rows long. For the sake of ease (and also to not share PHI), I made a shortened 27-row long example; this is what is shown in the screenshots. The data I'm working with is downloaded from a website we use to give people questionnaires. Sometimes, people do not have very straightforward answers to each question, so we type in "comments" in those cases to help clarify the exact answer participants gave. The data I'm working with lists the ID number we gave to each participant; the "variable" AKA the name of the question (tells me exactly which question it is in our questionnaire); which "session" AKA appointment the question is from (we repeat the questionnaire multiple times per participant throughout a year, some in-person, some over the phone); which coworker left the comment (commenter); and finally the actual comment itself. We are trying to see which questions/variables were given comments most often. This is a replica of what I have: https://preview.redd.it/9lvlnwplfgng1.png?width=1025&format=png&auto=webp&s=4716f993d500383af6307b8fb1724fef5b8626e1 This is what i WANT it to sort of look like: https://preview.redd.it/3d4w5a6ofgng1.png?width=980&format=png&auto=webp&s=dd32c658aceadd0afe5c427f0ec19177226d5081 In other words, I want: A count of how many times each type of variable repeats in the excel file. the dataset to be organized from which variable appears the MOST often at the top, and the ones that show up the LEAST at the bottom. to get rid of all rows that were for a "test" participant (notice the "test" rows 8, 18, and 26 in the first screenshot are gone in the second). to be able to find an exact question from the questionnaire website based on this sheet. for example, if I wanted to look more into the context behind row 5's comment, I would know to go to our questionnaire website, go to participant 111's questionnaires from the Lab 1 appointment and specifically look at the alcohol_amount1 question. In other words it is important to keep the participant number and session information. It doesn't need to look exactly like the second picture, that was just the first way to organize it that came to mind. As long as it fills the above requirements that all I need that's what matters. I was trying out pivot tables but I couldn't really get it to look in a way that made sense to me. I really don't know what else to do besides comb through all 3000+ rows one by one... sorry if any of this doesnt fit the exact posting rules. I tried. thanks for any help in advance🥹 submitted by /u/soupysyrup [link] [comments]
- Creating a graphic with custom located cells populated by a pivot tableI want to create a graphic with drop down menus that work off of each. So, I select the "Bore size" and the "Class". After I want custom placed cells to populate with the appropriate information based on a separate worksheet that has all of the information for each value. (First Picture Below) Red represents my drop down menus. Once I have populated that, I have a separate spreadsheet (pictured below) with the columns detailed for which variable they are to fill, and it will give me my values accordingly. What terms and capabilities with Excel should I be researching to be able to achieve this? I'm assuming "Pivot Tables" for referencing the information from Sheet 2 to Sheet 1, but I don't know how to get the information to place itself appropriately into the blue sections. Do I have to merge cells to fit there, or can I draw custom cell placement? TIA Also, does anyone know what you would call this type of chart in Excel? The best answer I have so far is "Lookup-Driven Dashboard". Sheet 1 https://preview.redd.it/o4ptbz0ayvmg1.png?width=1325&format=png&auto=webp&s=bddd06bc28023fba707942fd7bdade6341447e7d Sheet 2 https://preview.redd.it/3odfm92ryvmg1.png?width=472&format=png&auto=webp&s=a7c3c27880a79f63916ccc8ff5a1064458bcd239 submitted by /u/West-Doubt6824 [link] [comments]
- I am trying to prevent the end user from having to insert data twice to see it on two different sheets, and the formulas I've been trying aren't copy/pasting well.I have been making a CRM spreadsheet for a finance business with over 100 clients. In trying to optimize the formatting, I have developed two different views which have two different uses. Sheet 1 is "2026 List View" where the informaiton is all on one row per client. It is annoying to side scroll to see all of the information, but it gives the best overall view as to who has paid. https://preview.redd.it/1yinsuhafikg1.png?width=3370&format=png&auto=webp&s=7559a5cfc76b671e2bbcc4b4700c446e2531ce46 Sheet 2 is "2026 Grid View" where the informaiton is organized differently to not need side-scrolling, and gives a better quick per-client view. https://preview.redd.it/2oip1qrbfikg1.png?width=2697&format=png&auto=webp&s=7b4f9f29f34db95d14e17df60efca580ff4c546a I am writing formulas for Sheet 2's cells to reference Sheet 1's data. For example, Sheet 2's cell B3 has ='2026 List View'!A2 and it is working well in terms of the formula. However, once I finished two tables refrerencing cells in rows 2 and then 3, copy/pasting made the next table do the correct columns but in the rows 16 and 17 instead of 3 and 4. I tried continuing the pattern longer, but copy/pasting still made it skip several rows though it is recognizing the correct columns. Is there a different formula I could use to make the copy/pasting more successful? Or, am I stuck doing this cell by cell for 100 rows, making it not worth the hassle? submitted by /u/urgrlB [link] [comments]
- Moving values from Rows to columnshttps://preview.redd.it/288y8qscihyg1.png?width=1553&format=png&auto=webp&s=f3fce236e7ff84eeb553feb1911f70945d1c86fc https://preview.redd.it/c9y3sk00jhyg1.png?width=402&format=png&auto=webp&s=57d166f276f426ecd0f658a8ff91fcdf19998216 Please see the Screenshot attached I have a large spreadsheet like this. There is a mandarin word followed by the Pinyin, English and an example sentence all in rows. This repeats for many different words. Each word has those same 3 accompanying values laid out underneath it in rows. Is there a formula I can use to layout each word and its accompanying values in columns and repeat that for the whole document without copy and pasting Wraparrows loads of times.? Example screenshot attached. Note: screenshots taken in Googlesheets, but will use Excel. 10,000 words in total. 40,000 rows. Have tried using AI, but it makes too many mistakes Any help appreciated :). Am Losing my mind. :( submitted by /u/Lost-Presence-2818 [link] [comments]