split

I have data in sheet Check of the excel file .test file and expected result Bot_Container_Size Bot_Container_Height Bot_Container_Type Bot_Remarks_By_ContainerInfo Bot_Website_Gross_Weight_ConvertUnit Bot_PickUp_Place ;20':20FT;40'GP:40FT;40'HC:40FT Small ;20':Not Applicable;40'GP:OK to...

Populate Rows & Columns by Comma Split version 1 Good day mate, got the problem above solved! but it would be a bit of a problem to implement since my sheet column is dynamic starting from 96 columns and 6000 rows on a quarterly period would anyone kindly help this poor guy to implement a...

Good Morning, I have a set of data with start/end dates which I am trying to split into hour categories so I can dissect further (i.e if a line starts at 5am and ends at 7am I would expect to see 1 hour in the 5 and 6 am columns) My formula splits things up nicely but when the end date falls in...

Hello I use a macro to save mail merged documents into word and PDF files; very handy. I must select all the rows above the row I need in the recipient list for it to work. If I only ticked "Sam" and left "Connor" and "Vincent" unticked, the macro will produce a "runtime error 5631" on...

I named 4 different sections of cells as a range name, specifically sheet 2 a1:a5, a10:a15 and a20:a25. named it "split" I wanted to copy paste into same range on sheet 1 and named it "splittgt" It gets all the way to paste then gives me this error. "This action wont work on multiple...

Hi, we have the following sheet where we want to split in row wise instead of column wise, can we do this from macro or any formula, its a large database query sheet...

Hello All, I'm trying to create a macro which splits data out of textjoin formula and output it as list. I have created a macro which do that, but it's not moving the cells and the data is not correct. So I need to adjust the macro to add empty cell in column G to keep up with the data. Here...

Hello, I'm having troubles figuring this out. I have an external Array in a notepad, where there are a Bunch of strings. I Want to make a new Array from a line from this Array. Say "Arr(0)" contains the following:1 2 3 4 5 6 7 8 From there I want a new array (lets call it nArr) that can...

Hi See sample data: ABCDEFGHIJKL1Product CodeOrderOrdered PartsIntended...

Good evening everyone, I'm new to VBA and i need a simple VBA code to split a sheet into new workbooks based on data in column F (Date), so i can create several workbooks based on date. TYPE Loc Code Area Source Date ZUST 1233 277884 3 3333 20230216 ZUST 1233 277886 3...

Hello Do you think that would be possible to merge both formulas/functions in order to obtain my ColumnLetter value ? If so, what would be the proper syntax? Dim ColumnNumber As Long Dim ColumnLetter As String ColumnNumber = WorksheetFunction.Match("Column Name", Rows("1:1"), 0)...

How do I convert each row into a list without adding a new column? What I have so far: = Table.TransformColumns(TESTT, each Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv)([TESTT])) It gives error: Expression.Error: We cannot convert a value of type Function to type List. Details...

Hi I have a column of values which has different suffix after a dot, i need it to group it based on the value after dot. Example i need to split all values that end with .pdf into one column, values with.xls as another column, etc,,, how to do this is my doubt.

TextSplitVar is a recursive formula to split a single cell or text array by the delimiter and return the variable chosen. It checks the number of variables and provides the last variable if the user asked for too large a number. It also adds one more delimiter at the end on the first iteration...

We have a spreadsheet with thousands of rows, that looks like this: We need to (if at all possible with formulas only) separate the data (; is the separator) in such a way that the first row above ends up looking like this (obviously it's needed for all the rows, the data must be moved...

Hello, I have list of 15000 names which I want to split in Column 1, Column 2, City, State, Zip, Country. The problem is they don't have any particular order. They are of different countries Some has Zip code, some don't Some has city, Some don't Some has university department (multiple), so...

Good evening, I would really appreciate a help on this problem Suppose i have a 50 pieces of an item in my warehouse and i want to send it to 2 selling points. The one selling point has already 10 pieces and the other 20 pieces. What formula do i need to give me the solution of having equal...

Good Afternoon I have the following worksheet (sheet1) im needing to split any rows that contain a comma delimited value in the desc column into a new line and maintain all other other values. Is there a easy way? (you can see that the 1st row desc contains the values blue,red,yellow...

Hello All, This requirement is about assigning tasks to my team on a daily basis. > Effort required for each task & per task is constant & listed >Backlog count of each task may vary on a daily basis or even task name might increase >Agents in the team might vary >There will a Yes or No for...

I have looked at other questions but haven't quite found the answer I need. I have a column with data in it split by delimiter ; 1;4;10;23; etc.. each row could have anything from 1 to 26 items in that column all split by delimiter I have 26 columns set up to take the data one column...