text to rows

Hi All I'm trying to do the following with no luck Current: Headers: Name | Programs Enrolled In | Date Enrolled in Program Row 1: Name A | Program A, Program B, Program C | 1/25/2021, 5/25/2020, 6/14/2019 Row 2: Name B | Program A, Program E...

Hi, How can i convert comma separated text in a cell into multiple rows along with data in other columns. I would want to do this for about 6000 rows and don't want to stay away from using VBA. Can someone please help. Example:- <tbody> Restaurant Cuisine Countries ABC Chinese Australia...

Hi experts, Wondering how to convert ~2000 txt records into rows in a table for refining, then doing email merge and import into email programs etc. For each record, 12-16 out of 16 attributes would be available. I have two columns of text, where Column B holds the actual values for each record...

Hi, I have no idea how to approach this but basically I have columns that have IDs, Customer Name, Tax Number separated by semicolons. I need to split these into multiple rows but the tough part is that basically I need to take the first ID and take the first customer name and first tax ID and...

Hi there , what i would like to do is use a function that is similar to the Text to columns , but instead do Text to rows. So for example my table would start off being like this <COLGROUP><COL style="WIDTH: 142pt; mso-width-source: userset; mso-width-alt: 6912" width=189><COL...

Hello all, I have a question I have not seen answered yet, and I have no idea how to accomplish this. I have some data which shares some common elements, but has unique values. Some cells have multiple items separated by a linefeed (Alt+Return) as in the description column. For example I would...

Hi all! I'm trying to work with tweets database for the floods in Alberta, Ca in 2013. So I need instead of this: IDtweet Hashtags Date Other columns 123456789 yycflood#abflood#calgary 01/01/2013 this: IDtweet Hashtags Date Other columns 123456789...

Hi All, I am working on a dynamic spreadsheet sucking information from our company CRM platform (Microsoft Dynamics). Column B details facility number, which ranges between 2 - 4 numbers, however there may be 2 facilities to the same client (and row) as illustrated below: <tbody> 10/09/2008...

Folks, This is my first time posting :eeek: and am really grateful for any help with my puzzle! I'm working on a project where I have to count author publications across several academic journals. I have downloaded and organized all the data for these journals, but have been struggling to...

Hi all. First time here. Have a question and haven't been able to find an answer yet in a few hours of searching, so here I am. I am running MS Excel 2003. A user inputs a string of letters/symbols all meaning different things. These would typically for my case be L, R, +, -, F. These...

Good day to you all, and thank you in advance. I am running Excel 2003, having severe difficulty performing what feels like it should be a very simple macro. I have cells from Column A through M, and the text in column A has multiple data points of various character lengths from 2 to 8...

All right . . . I have been bashing my head against a wall for two days now because I got interested in solving this issue. I have a cell that contains thousands of names in the following format: Smith MD, Bob; Savage DDS, Fred; Doe MD, Jane; . . . et cetera I have already fixed the issue...

Good day I have a string of text that I am trying to split and make into multiple rows. The text isnt the same length and changes from cell to cell. An example of a couple rows of what I have is <TABLE style="WIDTH: 271pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0...