Hi,
I'm trying to move a dataset into a new set of columns every time a descriptor appears.
More specifically, if you look at linked images, I would like to move the corresponding dataset to new columns every time the word "particle" appears.
Linked image #1 ...
Hi!
I have data that is output from a measuring machine.
The machine outputs numerical data with a one letter descriptor of direction into each cell.
For example in row one I have 0.1 H, 0.2 B, 0.1 I, 0.4 F
All of the results are positive numbers with a descriptor.
The descriptor tells me...
I have a roster of people with names in column B and number data about them in columns H, I, J, K. Column A has a descriptor about the person. Everyone has the descriptor of "NO" in column A when they are added to the roster. If they are added again, they are given the descriptor in column A...
Hi,
First off, I love this board! Very helpful.
I have a report (excel format) of data that has the amounts for each date in a separate column:
Descriptor Descriptor Jan-18 Feb-18 Mar-18 and so forth
I have been given many existing data coded as follows "EXMPL1A 05/25/2018 2,150.00 D" (without quote marks) each datum is this format: a descriptor, space, date in mm/dd/yyyy, space, Amount numeric with 2 places to the right of the decimal, space, alpha-character.
I need to convert the example...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.