Vba code

A

AFPMM

New Member
Joined
Sep 21, 2016
Messages
4
Hello!
Could you give me some help with a vba code to organize this data? I've imported this table from a source pdf and organized it by columns.
Now, the goal was to concatenate the columns with text (including column A) and then pass thru the numerical values and paste them from right to left. So that the last value is aligned in the same column.
Thanks!!





[TABLE="class: grid, width: 1591, align: center"]
<tbody>[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]EX[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]5E+07[/TD]
[TD="align: center"]1,72E+08[/TD]
[TD="align: center"]2,6E+08[/TD]
[TD="align: center"]5,02E+08[/TD]
[TD="align: center"]8,76E+08[/TD]
[TD="align: center"]3,39E+08[/TD]
[TD="align: center"]1,77E+09[/TD]
[TD="align: center"]1,78E+08[/TD]
[TD="align: center"]1,18E+08[/TD]
[TD="align: center"]-6E+07[/TD]
[TD="align: center"]1,11E+09[/TD]
[TD="align: center"]1,27E+08[/TD]
[TD="align: center"]3,39E+08[/TD]
[TD="align: center"]2,46E+08[/TD]
[TD="align: center"]2,46E+08[/TD]
[TD="align: center"]-9,3E+07[/TD]
[TD="align: center"]1,23E+09[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]0[/TD]
[TD="align: center"]FEL[/TD]
[TD="align: center"]ST[/TD]
[TD="align: center"]2012[/TD]
[TD="align: center"]5E+07[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]-3041183[/TD]
[TD="align: center"]-920341[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]49836698[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]49836698[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]0.1[/TD]
[TD="align: center"]DEVELOPMENT[/TD]
[TD="align: center"]STUDIES[/TD]
[TD="align: center"]49109159[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]-3E+06[/TD]
[TD="align: center"]-401769[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]45666208[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]45666208[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]0.2[/TD]
[TD="align: center"]FIELD[/TD]
[TD="align: center"]ACTIVITIES[/TD]
[TD="align: center"]4689062[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]-518572[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]4170490[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]4170490[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]FEL[/TD]
[TD="align: center"]STUDIES[/TD]
[TD="align: center"]2013-2016[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1E+06[/TD]
[TD="align: center"]348055[/TD]
[TD="align: center"]683673[/TD]
[TD="align: center"]838032[/TD]
[TD="align: center"]838032[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]530138[/TD]
[TD="align: center"]196320[/TD]
[TD="align: center"]-333818[/TD]
[TD="align: center"]2623447[/TD]
[TD="align: center"]719000[/TD]
[TD="align: center"]697872[/TD]
[TD="align: center"]850320[/TD]
[TD="align: center"]915320[/TD]
[TD="align: center"]77288[/TD]
[TD="align: center"]3342447[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1.1[/TD]
[TD="align: center"]GENERAL[/TD]
[TD="align: center"]STUDIES[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1E+06[/TD]
[TD="align: center"]348055[/TD]
[TD="align: center"]683673[/TD]
[TD="align: center"]838032[/TD]
[TD="align: center"]838032[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]530138[/TD]
[TD="align: center"]196320[/TD]
[TD="align: center"]-333818[/TD]
[TD="align: center"]2623447[/TD]
[TD="align: center"]719000[/TD]
[TD="align: center"]697872[/TD]
[TD="align: center"]850320[/TD]
[TD="align: center"]915320[/TD]
[TD="align: center"]77288[/TD]
[TD="align: center"]3342447[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]ST[/TD]
[TD="align: center"]DEVELOPMENT[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1E+08[/TD]
[TD="align: center"]1,57E+08[/TD]
[TD="align: center"]1,99E+08[/TD]
[TD="align: center"]1,85E+08[/TD]
[TD="align: center"]1,85E+08[/TD]
[TD="align: center"]4,4E+08[/TD]
[TD="align: center"]94778334[/TD]
[TD="align: center"]66143403[/TD]
[TD="align: center"]-2,9E+07[/TD]
[TD="align: center"]5,55E+08[/TD]
[TD="align: center"]77620727[/TD]
[TD="align: center"]1,95E+08[/TD]
[TD="align: center"]1,44E+08[/TD]
[TD="align: center"]1,44E+08[/TD]
[TD="align: center"]-4,1E+07[/TD]
[TD="align: center"]6,33E+08[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]M[/TD]
[TD="align: center"]STR[/TD]
[TD="align: center"]DEVELOPMENT[/TD]
[TD="align: center"]-[/TD]
[TD="align: center"]CS[/TD]
[TD="align: center"]Phase[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1,33E+08[/TD]
[TD="align: center"]98060410[/TD]
[TD="align: center"]-1882650[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]-2619966[/TD]
[TD="align: center"]-2619966[/TD]
[TD="align: center"]2,26E+08[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]-2616765[/TD]
[TD="align: center"]-2619966[/TD]
[TD="align: center"]-2619966[/TD]
[TD="align: center"]-2619966[/TD]
[TD="align: center"]2,26E+08[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2.1[/TD]
[TD="align: center"]STR[/TD]
[TD="align: center"]CONCEPT[/TD]
[TD="align: center"]SELEC[/TD]
[TD="align: center"]UPS[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]77243320[/TD]
[TD="align: center"]46500323[/TD]
[TD="align: center"]-3274592[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]-258381[/TD]
[TD="align: center"]-258381[/TD]
[TD="align: center"]1,2E+08[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]-539400[/TD]
[TD="align: center"]-258381[/TD]
[TD="align: center"]-258381[/TD]
[TD="align: center"]-258381[/TD]
[TD="align: center"]1,2E+08[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2.1.1[/TD]
[TD="align: center"]PROJECT[/TD]
[TD="align: center"]MANAGEMENT[/TD]
[TD="align: center"]/[/TD]
[TD="align: center"]DIRECTORATE[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]24288087[/TD]
[TD="align: center"]16571036[/TD]
[TD="align: center"]-1523567[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]283484[/TD]
[TD="align: center"]283484[/TD]
[TD="align: center"]39619040[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]283484[/TD]
[TD="align: center"]283484[/TD]
[TD="align: center"]283484[/TD]
[TD="align: center"]39619040[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2.1.2[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]17256108[/TD]
[TD="align: center"]1E+07[/TD]
[TD="align: center"]686280[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]-539400[/TD]
[TD="align: center"]-539400[/TD]
[TD="align: center"]29722842[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]-539400[/TD]
[TD="align: center"]-539400[/TD]
[TD="align: center"]-539400[/TD]
[TD="align: center"]-539400[/TD]
[TD="align: center"]29722842[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2.1.3[/TD]
[TD="align: center"]PRE-f[/TD]
[TD="align: center"]STUDIES[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1E+07[/TD]
[TD="align: center"]1E+07[/TD]
[TD="align: center"]-2407233[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]20026544[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]20026544[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2.1.4[/TD]
[TD="align: center"]SURVEYS[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]24611712[/TD]
[TD="align: center"]6E+06[/TD]
[TD="align: center"]-31359[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]-2465[/TD]
[TD="align: center"]-2465[/TD]
[TD="align: center"]30706969[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]-2465[/TD]
[TD="align: center"]-2465[/TD]
[TD="align: center"]-2465[/TD]
[TD="align: center"]30706969[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2.1.5[/TD]
[TD="align: center"]ESH[/TD]
[TD="align: center"]-[/TD]
[TD="align: center"]H[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]113968[/TD]
[TD="align: center"]20021[/TD]
[TD="align: center"]1287[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]135276[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]135276[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2.2[/TD]
[TD="align: center"]S[/TD]
[TD="align: center"]CONCEPT[/TD]
[TD="align: center"]SELECTION[/TD]
[TD="align: center"]MIDS[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]55687591[/TD]
[TD="align: center"]51560086[/TD]
[TD="align: center"]1391942[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]-2361585[/TD]
[TD="align: center"]-2361585[/TD]
[TD="align: center"]1,06E+08[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]-2077365[/TD]
[TD="align: center"]-2361585[/TD]
[TD="align: center"]-2361585[/TD]
[TD="align: center"]-2361585[/TD]
[TD="align: center"]1,06E+08[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2.2.1[/TD]
[TD="align: center"]PROJECT[/TD]
[TD="align: center"]MANAGEMENT[/TD]
[TD="align: center"]/[/TD]
[TD="align: center"]DIRECTORATE[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]17853173[/TD]
[TD="align: center"]15046975[/TD]
[TD="align: center"]627282[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]-284148[/TD]
[TD="align: center"]-284148[/TD]
[TD="align: center"]33243282[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]-284148[/TD]
[TD="align: center"]-284148[/TD]
[TD="align: center"]-284148[/TD]
[TD="align: center"]33243282[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2.2.2[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]2824759[/TD]
[TD="align: center"]9E+06[/TD]
[TD="align: center"]2E+06[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]-2077365[/TD]
[TD="align: center"]-2077365[/TD]
[TD="align: center"]12223147[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]-2077365[/TD]
[TD="align: center"]-2077365[/TD]
[TD="align: center"]-2077365[/TD]
[TD="align: center"]-2077365[/TD]
[TD="align: center"]12223147[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2.2.3[/TD]
[TD="align: center"]PRE-f[/TD]
[TD="align: center"]STUDIES[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]3E+07[/TD]
[TD="align: center"]2E+07[/TD]
[TD="align: center"]-362092[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]53539182[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]53539182[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2.2.4[/TD]
[TD="align: center"]SURVEYS[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]3868712[/TD]
[TD="align: center"]2E+06[/TD]
[TD="align: center"]73344[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]6091385[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]6091385[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2.2.5[/TD]
[TD="align: center"]ESH[/TD]
[TD="align: center"]-[/TD]
[TD="align: center"]HSE[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]509241[/TD]
[TD="align: center"]1612695[/TD]
[TD="align: center"]-940827[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]-72[/TD]
[TD="align: center"]-72[/TD]
[TD="align: center"]1181037[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]-72[/TD]
[TD="align: center"]-72[/TD]
[TD="align: center"]-72[/TD]
[TD="align: center"]1181037[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]M[/TD]
[TD="align: center"]S[/TD]
[TD="align: center"]DEVELOPMENT[/TD]
[TD="align: center"]-[/TD]
[TD="align: center"]CD[/TD]
[TD="align: center"]Phase[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]59005505[/TD]
[TD="align: center"]2,01E+08[/TD]
[TD="align: center"]1,77E+08[/TD]
[TD="align: center"]1,77E+08[/TD]
[TD="align: center"]1,46E+08[/TD]
[TD="align: center"]92348334[/TD]
[TD="align: center"]68763369[/TD]
[TD="align: center"]-2,4E+07[/TD]
[TD="align: center"]3,28E+08[/TD]
[TD="align: center"]75206327[/TD]
[TD="align: center"]1,89E+08[/TD]
[TD="align: center"]1,45E+08[/TD]
[TD="align: center"]1,45E+08[/TD]
[TD="align: center"]-3,2E+07[/TD]
[TD="align: center"]4,04E+08[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2.3[/TD]
[TD="align: center"]S[/TD]
[TD="align: center"]CONCEPT[/TD]
[TD="align: center"]DEFINITION[/TD]
[TD="align: center"]UP[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]42199528[/TD]
[TD="align: center"]1,14E+08[/TD]
[TD="align: center"]1,03E+08[/TD]
[TD="align: center"]1,03E+08[/TD]
[TD="align: center"]77626361[/TD]
[TD="align: center"]49730650[/TD]
[TD="align: center"]43717188[/TD]
[TD="align: center"]-6013462[/TD]
[TD="align: center"]2E+08[/TD]
[TD="align: center"]52639297[/TD]
[TD="align: center"]1,04E+08[/TD]
[TD="align: center"]95841380[/TD]
[TD="align: center"]96917990[/TD]
[TD="align: center"]-5723620[/TD]
[TD="align: center"]2,53E+08[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
Sort by date Sort by votes
Now, the goal was to concatenate the columns with text (including column A) and then pass thru the numerical values and paste them from right to left. So that the last value is aligned in the same column.

This is not at all clear
concatenate the columns with text - do you mean every column with text become just one column
4th column has text plus numbers

can you try to wxplain better please
 
Upvote 0
Thanks for the quick response.
This table is quite extense (I've only posted a small part). The importante values fullfill 17 columns. Is it possible to write a code to start reading from right to left and past the values?

The ideia is this :

[TABLE="width: 1244"]
<tbody>[TR]
[TD]A E EX EA[/TD]
[TD]5,00E+07[/TD]
[TD]1,72E+08[/TD]
[TD]2,60E+08[/TD]
[TD]5,02E+08[/TD]
[TD]8,76E+08[/TD]
[TD]3,39E+08[/TD]
[TD]1,77E+09[/TD]
[TD]1,78E+08[/TD]
[TD]1,18E+08[/TD]
[TD]-6,00E+07[/TD]
[TD]1,11E+09[/TD]
[TD]1,27E+08[/TD]
[TD]3,39E+08[/TD]
[TD]2,46E+08[/TD]
[TD]2,46E+08[/TD]
[TD]-9,30E+07[/TD]
[TD]1,23E+09[/TD]
[/TR]
[TR]
[TD]0FELST 2012[/TD]
[TD]5,00E+07[/TD]
[TD]0[/TD]
[TD]-3041183[/TD]
[TD]-920341[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]49836698[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]49836698[/TD]
[/TR]
[TR]
[TD]0.1 DEVELOPMENT STUDIES[/TD]
[TD]49109159[/TD]
[TD]0[/TD]
[TD]-3,00E+06[/TD]
[TD]-401769[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]45666208[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]45666208[/TD]
[/TR]
[TR]
[TD]0.2 FIELD ACTIVITIES[/TD]
[TD]689062[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]-518572[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]4170490[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]4170490[/TD]
[/TR]
[TR]
[TD]1 FEL STUDIES 2013-2016[/TD]
[TD]0[/TD]
[TD]1,00E+06[/TD]
[TD]348055[/TD]
[TD]683673[/TD]
[TD]838032[/TD]
[TD]838032[/TD]
[TD]0[/TD]
[TD]530138[/TD]
[TD]196320[/TD]
[TD]-333818[/TD]
[TD]2623447[/TD]
[TD]719000[/TD]
[TD]697872[/TD]
[TD]850320[/TD]
[TD]915320[/TD]
[TD]77288[/TD]
[TD]3342447[/TD]
[/TR]
</tbody>[/TABLE]

Thanks again
 
Upvote 0
still not clear to me

[TABLE="class: cms_table_grid, width: 1591, align: center"]
<tbody>[TR]
[TD="align: center"]0.1[/TD]
[TD="align: center"]DEVELOPMENT[/TD]
[TD="align: center"]STUDIES[/TD]
[TD="align: center"]49109159
what is this number text or value[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
I now understand it and as an academic exercise submit this.... MORE DATA OVER TO THE RIGHT > > > > > >

[TABLE="width: 2782"]
<tbody>[TR]
[TD]A E EX E A[/TD]
[TD]50000000[/TD]
[TD]1,72E+08[/TD]
[TD]2,6E+08[/TD]
[TD]5,02E+08[/TD]
[TD]8,76E+08[/TD]
[TD]3,39E+08[/TD]
[TD]1,77E+09[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0 FEL ST[/TD]
[TD]2012[/TD]
[TD]50000000[/TD]
[TD]0[/TD]
[TD]-3.04E+06[/TD]
[TD]-920341[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0.1 DEVELOPMENT STUDIES[/TD]
[TD]49109159[/TD]
[TD]0[/TD]
[TD]-3000000[/TD]
[TD]-401769[/TD]
[TD]0.00E+00[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0.2 FIELD ACTIVITIES[/TD]
[TD]4689062[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]-518572[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1 FEL STUDIES[/TD]
[TD]2013-2016[/TD]
[TD]0[/TD]
[TD]1000000[/TD]
[TD]348055[/TD]
[TD]6.84E+05[/TD]
[TD]838032[/TD]
[TD]838032[/TD]
[TD]0[/TD]
[TD]530138[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1.1 GENERAL STUDIES[/TD]
[TD]0[/TD]
[TD]1000000[/TD]
[TD]348055[/TD]
[TD]6.84E+05[/TD]
[TD]838032[/TD]
[TD]838032[/TD]
[TD]0[/TD]
[TD]530138[/TD]
[TD]196320[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2 M ST DEVELOPMENT[/TD]
[TD]0[/TD]
[TD]100000000[/TD]
[TD]1,57E+08[/TD]
[TD]1,99E+08[/TD]
[TD]1,85E+08[/TD]
[TD]1,85E+08[/TD]
[TD]4,4E+08[/TD]
[TD]94778334[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]M STR DEVELOPMENT[/TD]
[TD]-[/TD]
[TD]CS[/TD]
[TD]Phase[/TD]
[TD]0[/TD]
[TD]1,33E+08[/TD]
[TD]98060410[/TD]
[TD]-2E+06[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2.1 STR CONCEPT SELEC UPS[/TD]
[TD]0[/TD]
[TD]77243320[/TD]
[TD]46500323[/TD]
[TD]-3274592[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2.1.1 PROJECT MANAGEMENT yyy DIRECTORATE[/TD]
[TD]0[/TD]
[TD]24288087[/TD]
[TD]16571036[/TD]
[TD]-1523567[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2.1.2 E[/TD]
[TD]0[/TD]
[TD]17256108[/TD]
[TD]10000000[/TD]
[TD]6.86E+05[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]-539400[/TD]
[TD]-539400[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2.1.3 PRE-f STUDIES[/TD]
[TD]0[/TD]
[TD]10000000[/TD]
[TD]10000000[/TD]
[TD]-2.41E+06[/TD]
[TD]0.00E+00[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2.1.4 SURVEYS[/TD]
[TD]0[/TD]
[TD]24611712[/TD]
[TD]6000000[/TD]
[TD]-3.14E+04[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]-2465[/TD]
[TD]-2465[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2.1.5 ESH[/TD]
[TD]-[/TD]
[TD]H[/TD]
[TD]0[/TD]
[TD]113968[/TD]
[TD]20021[/TD]
[TD]1287[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2.2 S CONCEPT SELECTION MIDS[/TD]
[TD]0[/TD]
[TD]55687591[/TD]
[TD]51560086[/TD]
[TD]1391942[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2.2.1 PROJECT MANAGEMENT[/TD]
[TD]/[/TD]
[TD]DIRECTORATE[/TD]
[TD]0[/TD]
[TD]17853173[/TD]
[TD]15046975[/TD]
[TD]627282[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2.2.2 E[/TD]
[TD]0[/TD]
[TD]2824759[/TD]
[TD]9000000[/TD]
[TD]2.00E+06[/TD]
[TD]0.00E+00[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]-2077365[/TD]
[TD]-2E+06[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2.2.3 PRE-f STUDIES[/TD]
[TD]0[/TD]
[TD]30000000[/TD]
[TD]20000000[/TD]
[TD]-3.62E+05[/TD]
[TD]0.00E+00[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2.2.4 SURVEYS[/TD]
[TD]0[/TD]
[TD]3868712[/TD]
[TD]2000000[/TD]
[TD]7.33E+04[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2.2.5 ESH[/TD]
[TD]-[/TD]
[TD]HSE[/TD]
[TD]0[/TD]
[TD]509241[/TD]
[TD]1612695[/TD]
[TD]-940827[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]M S DEVELOPMENT[/TD]
[TD]-[/TD]
[TD]CD[/TD]
[TD]Phase[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]59005505[/TD]
[TD]2,01E+08[/TD]
[TD]1,77E+08[/TD]
[TD]1,77E+08[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2.3 S CONCEPT DEFINITION UP[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]42199528[/TD]
[TD]1,14E+08[/TD]
[TD]1,03E+08[/TD]
[TD]1,03E+08[/TD]
[TD]7.8E+07[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]the original lower table was converted to the above by the macro[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD][/TD]
[TD]note that - and / prevent subsequent text from being processed[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]48[/TD]
[TD][/TD]
[TD]maybe you can replace dashes with something or insert leading space character[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]I left a delay loop in the code so you can see how it works[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]ORIGINAL DATA[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]j = 1[/TD]
[TD][/TD]
[TD]A[/TD]
[TD]E[/TD]
[TD]EX[/TD]
[TD]E[/TD]
[TD]A[/TD]
[TD]5.00E+07[/TD]
[TD]1,72E+08[/TD]
[TD]2,6E+08[/TD]
[TD]5,02E+08[/TD]
[TD]8,76E+08[/TD]
[TD]3,39E+08[/TD]
[TD]1,77E+09[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]50 For y = 1 To 5[/TD]
[TD][/TD]
[TD]0[/TD]
[TD]FEL[/TD]
[TD]ST[/TD]
[TD]2012[/TD]
[TD]5.00E+07[/TD]
[TD]0[/TD]
[TD]-3E+06[/TD]
[TD]-920341[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD] Cells(25, 1) = Left(Cells(j, 2), 1)[/TD]
[TD][/TD]
[TD]0.1[/TD]
[TD]DEVELOPMENT[/TD]
[TD]STUDIES[/TD]
[TD]4.9E+07[/TD]
[TD]0[/TD]
[TD]-3.00E+06[/TD]
[TD]-401769[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD] tempc = Cells(26, 1)[/TD]
[TD][/TD]
[TD]0.2[/TD]
[TD]FIELD[/TD]
[TD]ACTIVITIES[/TD]
[TD]4689062[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]-518572[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD] If tempc < 65 Then GoTo 100[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]FEL[/TD]
[TD]STUDIES[/TD]
[TD]2013-2016[/TD]
[TD]0[/TD]
[TD]1.00E+06[/TD]
[TD]348055[/TD]
[TD]683673[/TD]
[TD]838032[/TD]
[TD]838032[/TD]
[TD]0[/TD]
[TD]530138[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD] If tempc > 90 And tempc < 97 Then GoTo 100[/TD]
[TD][/TD]
[TD]1.1[/TD]
[TD]GENERAL[/TD]
[TD]STUDIES[/TD]
[TD]0[/TD]
[TD]1.00E+06[/TD]
[TD]348055[/TD]
[TD]683673[/TD]
[TD]838032[/TD]
[TD]838032[/TD]
[TD]0[/TD]
[TD]530138[/TD]
[TD]196320[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD] If tempc > 123 Then GoTo 100[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]M[/TD]
[TD]ST[/TD]
[TD]DEVELOPMENT[/TD]
[TD]0[/TD]
[TD]1.00E+08[/TD]
[TD]1,57E+08[/TD]
[TD]1,99E+08[/TD]
[TD]1,85E+08[/TD]
[TD]1,85E+08[/TD]
[TD]4,4E+08[/TD]
[TD]9.5E+07[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD] Cells(j, 1) = Cells(j, 1) & " " & Cells(j, 2)[/TD]
[TD][/TD]
[TD]M[/TD]
[TD]STR[/TD]
[TD]DEVELOPMENT[/TD]
[TD]-[/TD]
[TD]CS[/TD]
[TD]Phase[/TD]
[TD]0[/TD]
[TD]1,33E+08[/TD]
[TD]9.8E+07[/TD]
[TD]-2E+06[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD] For z = 2 To 15[/TD]
[TD][/TD]
[TD]2.1[/TD]
[TD]STR[/TD]
[TD]CONCEPT[/TD]
[TD]SELEC[/TD]
[TD]UPS[/TD]
[TD]0[/TD]
[TD]7.7E+07[/TD]
[TD]4.7E+07[/TD]
[TD]-3E+06[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD] Cells(j, z) = Cells(j, z + 1)[/TD]
[TD][/TD]
[TD]2.1.1[/TD]
[TD]PROJECT[/TD]
[TD]MANAGEMENT[/TD]
[TD]yyy[/TD]
[TD]DIRECTORATE[/TD]
[TD]0[/TD]
[TD]2.4E+07[/TD]
[TD]1.7E+07[/TD]
[TD]-2E+06[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD] For mydelay = 1 To 1000000[/TD]
[TD][/TD]
[TD]2.1.2[/TD]
[TD]E[/TD]
[TD]0[/TD]
[TD]1.7E+07[/TD]
[TD]1.00E+07[/TD]
[TD]686280[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]-539400[/TD]
[TD]-539400[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD] Next mydelay[/TD]
[TD][/TD]
[TD]2.1.3[/TD]
[TD]PRE-f[/TD]
[TD]STUDIES[/TD]
[TD]0[/TD]
[TD]1.00E+07[/TD]
[TD]1.00E+07[/TD]
[TD]-2E+06[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD] Next z[/TD]
[TD][/TD]
[TD]2.1.4[/TD]
[TD]SURVEYS[/TD]
[TD]0[/TD]
[TD]2.5E+07[/TD]
[TD]6.00E+06[/TD]
[TD]-31359[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]-2465[/TD]
[TD]-2465[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD] Next y[/TD]
[TD][/TD]
[TD]2.1.5[/TD]
[TD]ESH[/TD]
[TD]-[/TD]
[TD]H[/TD]
[TD]0[/TD]
[TD]113968[/TD]
[TD]20021[/TD]
[TD]1287[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]100 j = j + 1[/TD]
[TD][/TD]
[TD]2.2[/TD]
[TD]S[/TD]
[TD]CONCEPT[/TD]
[TD]SELECTION[/TD]
[TD]MIDS[/TD]
[TD]0[/TD]
[TD]5.6E+07[/TD]
[TD]5.2E+07[/TD]
[TD]1391942[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD] If j > 22 Then GoTo 200[/TD]
[TD][/TD]
[TD]2.2.1[/TD]
[TD]PROJECT[/TD]
[TD]MANAGEMENT[/TD]
[TD]/[/TD]
[TD]DIRECTORATE[/TD]
[TD]0[/TD]
[TD]1.8E+07[/TD]
[TD]1.5E+07[/TD]
[TD]627282[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD] GoTo 50[/TD]
[TD][/TD]
[TD]2.2.2[/TD]
[TD]E[/TD]
[TD]0[/TD]
[TD]2824759[/TD]
[TD]9.00E+06[/TD]
[TD]2.00E+06[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]-2E+06[/TD]
[TD]-2E+06[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]200 End Sub[/TD]
[TD][/TD]
[TD]2.2.3[/TD]
[TD]PRE-f[/TD]
[TD]STUDIES[/TD]
[TD]0[/TD]
[TD]3.00E+07[/TD]
[TD]2.00E+07[/TD]
[TD]-362092[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2.2.4[/TD]
[TD]SURVEYS[/TD]
[TD]0[/TD]
[TD]3868712[/TD]
[TD]2.00E+06[/TD]
[TD]73344[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2.2.5[/TD]
[TD]ESH[/TD]
[TD]-[/TD]
[TD]HSE[/TD]
[TD]0[/TD]
[TD]509241[/TD]
[TD]1612695[/TD]
[TD]-940827[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]M[/TD]
[TD]S[/TD]
[TD]DEVELOPMENT[/TD]
[TD]-[/TD]
[TD]CD[/TD]
[TD]Phase[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]5.9E+07[/TD]
[TD]2,01E+08[/TD]
[TD]1,77E+08[/TD]
[TD]1,77E+08[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2.3[/TD]
[TD]S[/TD]
[TD]CONCEPT[/TD]
[TD]DEFINITION[/TD]
[TD]UP[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]4.2E+07[/TD]
[TD]1,14E+08[/TD]
[TD]1,03E+08[/TD]
[TD]1,03E+08[/TD]
[TD]7.8E+07[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Last edited:
Upvote 0
See if this does what you want. Test in a copy of your workbook.

Code: 
Sub Rearrange()
  Dim a As Variant, b As Variant
  Dim i As Long, j As Long, k As Long
  
  a = Range("A1").CurrentRegion.Value
  ReDim b(1 To UBound(a), 1 To 18)
  For i = 1 To UBound(a)
    k = UBound(b, 2)
    j = UBound(a, 2)
    Do Until k = 1
      If a(i, j) <> vbNullString Then
        b(i, k) = a(i, j)
        k = k - 1
      End If
      j = j - 1
    Loop
    Do Until j = 0
      b(i, 1) = a(i, j) & " " & b(i, 1)
      j = j - 1
    Loop
    b(i, 1) = RTrim(b(i, 1))
  Next i
  Range("A" & Rows.Count).End(xlUp).Offset(3).Resize(UBound(b, 1), UBound(b, 2)).Value = b
End Sub

Below ..
- original data in rows 1:22.
- results of code in row 25 and below.


<div class="cms_table">

Excel 2010
ABCDEFGHIJKLMNOPQRSTUVW
1AEEXEA5.00E+071.72E+082.60E+085.02E+088.76E+083.39E+081.77E+091.78E+081.18E+08-6.00E+071.11E+091.27E+083.39E+082.46E+082.46E+08-9.30E+071.23E+09
20FELST20125.00E+070-3041183-920341000000498366980000049836698
30.1DEVELOPMENTSTUDIES491091590-3.00E+06-401769000000456662080000045666208
40.2FIELDACTIVITIES468906200-5185720000004170490000004170490
51FELSTUDIES2013-201601.00E+063480556836738380328380320530138196320-3338182623447719000697872850320915320772883342447
61.1GENERALSTUDIES01.00E+063480556836738380328380320530138196320-3338182623447719000697872850320915320772883342447
72MSTDEVELOPMENT01.00E+081.57E+081.99E+081.85E+081.85E+084.40E+089477833466143403-2.90E+075.55E+08776207271.95E+081.44E+081.44E+08-4.10E+076.33E+08
8MSTRDEVELOPMENT-CSPhase01.33E+0898060410-18826500000-2619966-26199662.26E+080-2616765-2619966-2619966-26199662.26E+08
92.1STRCONCEPTSELECUPS07724332046500323-32745920000-258381-2583811.20E+080-539400-258381-258381-2583811.20E+08
102.1.1PROJECTMANAGEMENT/DIRECTORATE02428808716571036-15235670000283484283484396190400028348428348428348439619040
112.1.2E0172561081.00E+076862800000-539400-539400297228420-539400-539400-539400-53940029722842
122.1.3PRE-fSTUDIES01.00E+071.00E+07-2407233000000200265440000020026544
132.1.4SURVEYS0246117126.00E+06-313590000-2465-24653070696900-2465-2465-246530706969
142.1.5ESH-H011396820021128700000013527600000135276
152.2SCONCEPTSELECTIONMIDS0556875915156008613919420000-2361585-23615851.06E+080-2077365-2361585-2361585-23615851.06E+08
162.2.1PROJECTMANAGEMENT/DIRECTORATE017853173150469756272820000-284148-2841483324328200-284148-284148-28414833243282
172.2.2E028247599.00E+062.00E+060000-2077365-2077365122231470-2077365-2077365-2077365-207736512223147
182.2.3PRE-fSTUDIES03.00E+072.00E+07-362092000000535391820000053539182
192.2.4SURVEYS038687122.00E+06733440000006091385000006091385
202.2.5ESH-HSE05092411612695-9408270000-72-72118103700-72-72-721181037
21MSDEVELOPMENT-CDPhase00590055052.01E+081.77E+081.77E+081.46E+089234833468763369-2.40E+073.28E+08752063271.89E+081.45E+081.45E+08-3.20E+074.04E+08
222.3SCONCEPTDEFINITIONUP00421995281.14E+081.03E+081.03E+08776263614973065043717188-60134622.00E+08526392971.04E+089584138096917990-57236202.53E+08
23
24
25A E EX E A500000001720000002600000005020000008760000003390000001770000000178000000118000000-600000001110000000127000000339000000246000000246000000-930000001230000000
260 FEL ST 2012500000000-3041183-920341000000498366980000049836698
270.1 DEVELOPMENT STUDIES491091590-3000000-401769000000456662080000045666208
280.2 FIELD ACTIVITIES468906200-5185720000004170490000004170490
291 FEL STUDIES 2013-2016010000003480556836738380328380320530138196320-3338182623447719000697872850320915320772883342447
301.1 GENERAL STUDIES010000003480556836738380328380320530138196320-3338182623447719000697872850320915320772883342447
312 M ST DEVELOPMENT01000000001570000001990000001850000001850000004400000009477833466143403-2900000055500000077620727195000000144000000144000000-41000000633000000
32M STR DEVELOPMENT - CS Phase013300000098060410-18826500000-2619966-26199662260000000-2616765-2619966-2619966-2619966226000000
332.1 STR CONCEPT SELEC UPS07724332046500323-32745920000-258381-2583811200000000-539400-258381-258381-258381120000000
342.1.1 PROJECT MANAGEMENT / DIRECTORATE02428808716571036-15235670000283484283484396190400028348428348428348439619040
352.1.2 E017256108100000006862800000-539400-539400297228420-539400-539400-539400-53940029722842
362.1.3 PRE-f STUDIES01000000010000000-2407233000000200265440000020026544
372.1.4 SURVEYS0246117126000000-313590000-2465-24653070696900-2465-2465-246530706969
382.1.5 ESH - H011396820021128700000013527600000135276
392.2 S CONCEPT SELECTION MIDS0556875915156008613919420000-2361585-23615851060000000-2077365-2361585-2361585-2361585106000000
402.2.1 PROJECT MANAGEMENT / DIRECTORATE017853173150469756272820000-284148-2841483324328200-284148-284148-28414833243282
412.2.2 E02824759900000020000000000-2077365-2077365122231470-2077365-2077365-2077365-207736512223147
422.2.3 PRE-f STUDIES03000000020000000-362092000000535391820000053539182
432.2.4 SURVEYS038687122000000733440000006091385000006091385
442.2.5 ESH - HSE05092411612695-9408270000-72-72118103700-72-72-721181037
45M S DEVELOPMENT - CD Phase00590055052010000001770000001770000001460000009234833468763369-2400000032800000075206327189000000145000000145000000-32000000404000000
462.3 S CONCEPT DEFINITION UP0042199528114000000103000000103000000776263614973065043717188-6013462200000000526392971040000009584138096917990-5723620253000000
Sheet3

</div>
 
Last edited:
Upvote 0
You must log in or register to reply here.

Forum statistics

Threads
1,223,099
Messages
6,170,114
Members
452,302
Latest member
TaMere

Share this page

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