Jumbled data into one column

brandon20

Board Regular
Joined
Feb 12, 2014
Messages
203
Hi,

I have a bunch of data that is poorly sorted in different columns. (Ie. Depth is in column A, B, C and so on)
I am attempting to put all the data into specified columns (Ie. Depth in only Column A)

I have put all the data into one worksheet and also concatenated the column name to the data. (Ie. all the data says 7453DEPTH, 8000DEPTH, and so on)

With the column name concatenated to the data itself I thought it would be easy to put all the jumbled data from a table array (A1:T24961) into lets say, column U.

If the data was not there then it would just say #N/A and if it was it would fill column U with 7453DEPTH and so forth.


Is there a way to do this? or a simpler method?

Any help is appreciated.

Thank you,
Brandon
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
Will the DEPTH cell show up more than once on a row? It should be a pretty simple find/replace macro where it looks in [ROW1] for a header name, searches all the data for the header word, and populates the column. Then it moves on to the next column header and does it again.
 
Upvote 0
Yes, the DEPTH cell will show up more than once, (as seen at the bottom.)
(I of course could get rid of all the cells that say only "DEPTH". But it sounds like they may be needed for the macro.
Just to make sure I explained my self correctly. Depth is in column A but as you keep going down it may change to something else (like DATE), which is why I need the macro.





THANKS!


DEPTHFPRESSUREHYDRO_AFTER
8845DEPTH-999.25FPRESSURE-999.25HYDRO_AFTER
8845DEPTH2801FPRESSURE5229.9102HYDRO_AFTER
8878DEPTH2710FPRESSURE5241.3301HYDRO_AFTER
8907DEPTH3007FPRESSURE5235.6201HYDRO_AFTER
8940DEPTH3389.3999FPRESSURE5241.3301HYDRO_AFTER
8982DEPTH3393.3999FPRESSURE4241.3301HYDRO_AFTER
8992DEPTH3436FPRESSURE5247.0498HYDRO_AFTER
9022DEPTH3215FPRESSURE5247.0498HYDRO_AFTER
9037DEPTH3251.8FPRESSURE5247.0498HYDRO_AFTER
9062DEPTH3247.8FPRESSURE5298.7998HYDRO_AFTER
9062DEPTH-999.25FPRESSURE5304.5898HYDRO_AFTER
9062DEPTH3247.9299FPRESSURE5304.5898HYDRO_AFTER
9087DEPTH3247.27FPRESSURE5304.5898HYDRO_AFTER
9087DEPTH3251FPRESSURE5293.0298HYDRO_AFTER
9097DEPTH3253.8FPRESSURE5287.2598HYDRO_AFTER
9110DEPTH3254FPRESSURE5281.5HYDRO_AFTER
9234DEPTH3685.3301FPRESSURE5310.3799HYDRO_AFTER
9257DEPTH3723FPRESSURE5316HYDRO_AFTER
9300DEPTH3766.27FPRESSURE5316.1699HYDRO_AFTER
9370DEPTH3770.27FPRESSURE5362HYDRO_AFTER
DEPTHFPRESSUREHYDRO_AFTER
8124DEPTH1531.2FPRESSURE4941.5698HYDRO_AFTER

<colgroup><col><col><col></colgroup><tbody>
</tbody>
 
Upvote 0
So what would a macro that could go through all the info from A1:T25075 and Find/Replace that data into columns look like?

Im not very good at writing VBA.
 
Upvote 0

Forum statistics

Threads
1,213,560
Messages
6,114,304
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

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.
Go back
Back
Top